Multiple sheets as data for a single sheet

N

Newbie1092

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?
 
P

PY & Associates

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 said:
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
Click to expand...
own?
 
Top