This is quite complicated. I have one master file containing, lets say Sheets A,B, & C. I want to save Sheets A,B, & C as separate workbooks.. then when those workbooks are updated with new information, I would like those same changes to transfer to the master file, containing the identical sheets. Does anyone have any guidance? Possibly linking an entire worksheet? Am I thinking of this incorrectly?

Please do not cross post without links !Read this to understand why : http://www.excelguru.ca/content.php?184

http://www.excelforum.com/excel-prog...in-master.html

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Also, If you don't mind, could you explain a bit more why you need to do this? Will the new data be updating existing records, are new records being added, or both? If at all possible, attach the master file.