Multiple sheets as data for a single sheet
 

I have 5 worksheets that contain data that a single worksheet needs to use.
Currently I manually copy / paste the data from each sheet into this mater
sheet and I would like to automate this process. My issue is that the 5 data
sheets always have a somewhat different file name. The name is always the
same except in the front of the file name is a 3 digit number that pertains
to a customer number and that part of the file can not be change. So, I have
a sheet like customer data that needs to retrieve informtion off of 5
seperate regional sales sheet and the name of the regional sales sheets are
like, 565Salesbycounty, 565Salesforquarter, 565TopPerformer, etc... How can I
have the master worksheet pull the data from the 5 other sheets on it's own?

Multiple sheets as data for a single sheet
 

put customer nr in A1, remaining file or sheet names in B1 to B5. Then the
complete filenames or sheetnames = $A$1 & Bi in Ci where i=1 to 5

"Newbie1092" wrote in message
...
I have 5 worksheets that contain data that a single worksheet needs to
use.
Currently I manually copy / paste the data from each sheet into this mater
sheet and I would like to automate this process. My issue is that the 5
data
sheets always have a somewhat different file name. The name is always the
same except in the front of the file name is a 3 digit number that
pertains
to a customer number and that part of the file can not be change. So, I
have
a sheet like customer data that needs to retrieve informtion off of 5
seperate regional sales sheet and the name of the regional sales sheets
are
like, 565Salesbycounty, 565Salesforquarter, 565TopPerformer, etc... How
can I
have the master worksheet pull the data from the 5 other sheets on it's
own?