did you ever get a response? Just my POV - if you are handing this off to someone that just wants to see a top line indicator of the process I would suggest using only 1 workbook (also easier to keep in sync) and you do the daily,weekly,monthly work behind the scenes
Create a dashboard with one simple parameter where the user selects - Day/Week or Month and you use a sheet swap to bring up the correct worksheet from the 3 that you have created and hidden - all the boss sees is the d/b and parameter -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.