Excell report questions

10 Years ago, created a multi tab report.  All but the 1st tab had info support for the 1st tab.  Th 11st tab pulled the report automatically from the supporting tabs.  1st tab could treat the inf a...