I have a sheet attached, i am trying to merge data from several sheets (30+in fact) and i want to sort the data. In its simplest form I have 2 sites, sheets names site 1 and site 2, and a master sheet. as the inspectors at the site move between the sites inspector a might turn up at site 1 and 2 at different times. On a Site sheet I would like to total all the inspections for each inspector and automatically add new inspectors as they turn up I would like to be able to On the master sheet have an over all total for each inspector regardless of which site.

the scale of the sample sheet is not relative it is just to outline what I am trying to achieve
Thanks
Darren

Page merge.xlsx