Hi

I have 5 excel files with the same header shared with 5 different users. users can input data in any excel file at any time they want.I want the 6th excel file named consolidated (which is not shared)to be automatically updated as and when any user enter data in the relevant field starting from row 2 as row 1 is the header. I am using excel 2010

Regards

Kris