Patricia, the original reference you posted is partly irrelevant. GB simply means that the documents originate in Great Britain, and 234 that they are in the National Records of Scotland.
The relevant part is SC9, which is the records of Dornoch Sheriff Court. This contains one thousand six hundred and three separate items.
SC9/7 is one of the 1603 parts of the SC9 series, and it contains 437 items.
SC9/7/6 is just one of these, and covers only one year, 1741 to 1742. It is likely to be either a large bound volume or a box of documents, and whichever it is it will probably run to hundreds of pages of handwriting.
If Hugh Macdonald was the Sheriff Clerk, he is likely to be mentioned in, or a signatory to, almost all the cases in which he was involved. There might perhaps be some record of his appointment which might tell you where he came from or what his qualifications for the job were, but most of the references to him in the Sheriff Court records are unlikely to shed any new light on his family connections.
There is no charge for research in the Historical Search Room, so it would not cost a volunteer anything to do this, but it could be a mammoth undertaking to sift through thousands of pages of handwritten documents. The SC9 series is stored off-site, so anyone undertaking the task for you would need to order the documents in advance of going there, so would have to know in sufficient detail exactly which volumes or bundles would be required.
Quite honestly, I think this request is much more than a simple lookup request, as it could take several days. I could certainly not volunteer to take it on! I think you need to consider hiring a professional researcher with experience of eighteenth century handwriting. There are links to lists of such researchers on the NRS web site.