Come up with a relationship type set up across different sheets in Smartsheet like how MS Access does with their tables. This will allow users to easily create reports using different sheets without having to have the sheets all mirror one another just for the information to flow properly.
You can set up relationships in MS Access across different tables. This way you can create a query that has different information from different tables all compiled into 1 Table, and from there create a report if you desire.
(Beginner Access Table)
(Intermediate Access Table)
In Smartsheet, you can't do that. If you try to create a report from 2 different sheets, this is the result...