Hello,

I have 5 different workbooks which are edited by different users, i.e. Cars, Bikes, Vans HGV, Other.

I then have a master workbook with 5 worksheets, one for each of the workbooks above. I regularly have to open each individual WB and update my master one.

Is there a way to automate this so that my master is updated each time one of the individual workbooks are amended and saved?

Also, would they all have to be on the same network file location?

Many thanks in advance for your valuable help.
Caz