Data analysis using pivot tables

I will have a collection of excel spread sheets with data submitted to me from 6-7 different places. I will need to consolidate the data and then set up pivot table to anayse what is in there. Date is simple HR metrics. A lot of requirements will be developed as we look at the data. I would imagine it is a four to five hours job, with constant interaction with the client on the phone. The ideal situation would be for the analyst to come into an office in CHeam, Surrey.