Creating An Excel Sheet That can use a scroll bar to scroll through diffrent Dates data

Hi Experts
I found an excel sheet online
What I love about this excel file is it has a scroll bar at bottom which you can use to scroll through different months

I have an excel file in which I crate a new page for everyday of the month
Can I use the same concept of using the scroll bar, instead of creating a new page everyday?

Is it hard to do? What do I need to do?

Can someone please guide me

I have attached the excel file I found as well as my excel sheet

Thanks
Kinds Regards

Rahul

Why create a sheet per day? Why not add the date and have one sheet (which makes any analysis/reporting much easier).

Originally Posted by JohnTopley

Why create a sheet per day? Why not add the date and have one sheet (which makes any analysis/reporting much easier).

Hi John
First I have the calculations being done on each page as to which room has done which jobs and how long it's taken them
This then copied across to the report sheet

The users who input have no excel training, I have shown them what to do and having just the day in front of their eyes makes it less confusing

Thanks