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. Does anyone have any guidance? THANK YOU!