I have a question regarding the linking of individual worksheets to a master file...

Is it possible to somehow establish a link between the individual worksheet files and a master file such that the formatting and any hyperlinks are transferred over, in addition to the data?