Sumif to Consolidate from Multiple Worksheets

Hi Y'all

I've attached a file that contains seven worksheets. Worksheets 2 to 6 contain daily revenues for 6 days. I need to consolidate the revenues onto Worksheet 1 using the sumif formula. The sumif formulas I have linked to the Worksheet "Day One Backlog". This is easy. I need to link the sumif formula to all the Worksheets that will give me the total revenues on Worksheet "HotelmappingReport" for each account.

What do you suggest?

Thanks

Patish