On a weekly basis we have 7 reports coming in from different locations and we compile these into one report to send out. What is the easiest way to get these sheets to automatically fill the master sheet weekly? Each location has their own sheet and we use a master sheet. Currently we just manually copy and paste the information, but there has to be an easier way.
