I am not sure how to do this, and I have searched through your multiple threads and haven't quite come across this, so here we go ...
I have production trackers in nine separate folders. I have a Master tracker in yet another folder. The production trackers have a vast amount of information and all workbooks contain at least two sheets, but some contain four sheets. All sheets have a set number of columns, but the rows are variable. I only need to move sheet2 and/or sheeet2 & sheet4 to the master tracker. There are formulas involved on each sheet, so I'm not feeling that linking the sheets will achieve what I want. I need to maintain the Master with the same integrity of the individual production trackers (i.e. formatting).
I have to compile the master tracker daily, and I have been basically using a copy and paste method, archiving yesterdays and saving today's in the same workbook. I should also mention the first sheet and/or third sheet on each tracker (including the master) is a reporting sheet that brings totals and counts to the front for the quick overview of the information.
I am not opposed to creating a master template with all the necessary formulas in place and populating the data from the respective sheets if that could work.
Any help, suggestions or a nudge in the right direction would be greatly appreciated.
I have production trackers in nine separate folders. I have a Master tracker in yet another folder. The production trackers have a vast amount of information and all workbooks contain at least two sheets, but some contain four sheets. All sheets have a set number of columns, but the rows are variable. I only need to move sheet2 and/or sheeet2 & sheet4 to the master tracker. There are formulas involved on each sheet, so I'm not feeling that linking the sheets will achieve what I want. I need to maintain the Master with the same integrity of the individual production trackers (i.e. formatting).
I have to compile the master tracker daily, and I have been basically using a copy and paste method, archiving yesterdays and saving today's in the same workbook. I should also mention the first sheet and/or third sheet on each tracker (including the master) is a reporting sheet that brings totals and counts to the front for the quick overview of the information.
I am not opposed to creating a master template with all the necessary formulas in place and populating the data from the respective sheets if that could work.
Any help, suggestions or a nudge in the right direction would be greatly appreciated.
