I have searched here on the board but can find the solution to my problem...

I have a workbook with a consolidated hours worked and each department has it’s own time sheet page where each persons total for the week is linked to the consolidated page. I have to add a special events sheet (the format and such is the same as the dept time sheet) The problem I am running into is how I can add John Does time from the special events page and his department totals to the consolidated page?

I hope I have made some sense of this to you all,

TIA
Rude

PS I can supply a copy of the workbook if needed