Pulling specific data from multiple worksheets into one

Occasional Visitor

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. 



1 Reply

You can checkout the link below for solution