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?