Referencing a detailed sheet from the master project sheet

New to SmartSheet, so I apologize if this is simple but I couldn't find the answer myself.

My organization uses a sheet to list all of our projects and under each project is the list of the activities. This is getting unwieldy. Is it possible to list all the projects on a master sheet and have the details on a separate, related sheet?

I am thinking that the detailed sheet could pass the needed information regarding progress to the master sheet and access to the detailed sheets could have different security.

Maybe there is a different way the office should be using sheets entirely.

Any insights or links to information would be greatly appreciated.

Answers