Switch() or better alternative?

[Tipsey]

I noticed in my spreadsheet I have 10 sheets that are essentially the same. They gather info and put it in a printable format. I was looking to shrink it all to one sheet using a data validated drop down box.
I will need to consolidate ten sheets of formulas into multiple switch formulas. Is there an easy way to do that?
Or can you think of an alternative solution?
Any option must be extremely user friendly.

Appreciate any thoughts people have to share on this topic.

 

[RoryA]

It's hard to suggest the best way without an idea of what the sheets do, and how they differ. Can you give an example of a formula that you think would need to be a SWITCH()?

 

[Tipsey]

Sorry about that. Hopefully this helps. One of the sheets looks in a table and finds all employees starting at a specific time. Using that list it then locates another part of the spreadsheet where those employees have been assigned to work for today and organizes it into an easily understandable way.

This process is repeated several times a day. In the past each start time has its own print sheet. This is making the entire sheet cumbersome. The goal is to have one sheet with a time selector and then by changing that one time, all relevant data changes to that would have been on each printout.

Hopefully that helps some.

 

[RoryA]

Is there anything other than the time value that is specific to that sheet? If not, I don't see how switch would come into it. You simply change the time value and have a filter function that returns all the data for that time.