Hi

I have got 9 spreadsheets which are created each day by someone else that detail how many types of each consignment we have for delivery that day for a specific customer.

I have to go in each day and total up the figures from all 9 spreadsheets. I would like to try and automate this process as much as possible.

The spreadsheet layout is always the same and so is the file name. The only bit that changes is the folder.

Is it possible that something can be written in VBA where a user can specify the folder name and then insert the rest as standard? E.g. insert a function like ='\\Network location\(user specified folder name)\[Filename.xls]Sheet1'!$B$17

Apologies for any typos, I've sent this from my phone

Regards
Jason