Hello,
I have the great honor (pfft) of coming up with a way to make sure my boss has an idea of what he needs to do for the day based on what his staff is doing. I realize there are other tools for this but he really wants a spreadsheet and is comfortable with the platform so I'm trying to accommodate.

Attached you'll see the mock workbook. My boss will refer only to his sheet and what I need to make happen is have 3 cells from multiple sheets carry over. If it was just 1 sheet mirroring data, my little knowledge of excel could handle it but where I get tripped up is the multiple sheets and making sure the information gets carried to the next row in the summary sheet. I've color coded the columns to help identify the what and where. Thank you in advance.Mock To Do.xlsxMock To Do.xlsxMock To Do.xlsx