Design to consolidate data
 

I got an urgent assignment and I need help on designing a way to consolidate
information from different locations. I designed a standard form for each
location to use so we are all consistent. On this form they will be reporting
the average number of employees out on a leave per week and the form
calculates the monthly weighted average as well as the monthly savings.

I need to roll the information up to by business unit, region (North
America, Asia Pacific, Europe) and country. But, when consolidating I only
need the monthly average of employees on leave and monthly savings.

Every business unit has a director that will be responsible to get the
locations updates and the directors will sent their locations data to me to
I can consolidate everything.

Do I create a separate file by business unit containing a separate sheet for
each location? Is there an automatic way to pull the data to consolidate the
information?