Visual Basic / Excel (multiple files into one?)

[Bern_21]

Ok here's the jest of it...

Know how you can have multiple "sheets" on one XLS file? Imagine there is one main office that has 1 Exel file with 4 sheets....these empty sheets are sent to 4 different branches nationwide, then at the end of the day sent back full of data. What program/trick can you use to combine the data into 1 Exel file...

Did this make sense whatsoeveR?

4 different sheets for 4 different branches..how to combine all that info received at the end of the day into one XLS file automatically (without the copy & paste function)

[LooseChippings]

If your '4 Branches' can access the workbook through a network you can 'Share the Workbook'.

See Sharing in Excel help.