Data viewing on other excel sheets using pull down tabs to direct data

Hello,

this will be difficult to achieve if the data is spread across several sheets. 

Put all the data into one sheet, one contiguous table, and add a column that specifies what sheet/category each row belongs to. 

Then you can easily build a pivot table that shows all the columns of the data and you can filter it with a slicer or a filter dropdown by the value in the sheet/category column. 

The approach you describe is cumbersome and can possibly be achieved with the Indirect() function, but Indirect() is volatile and will make your worksheet very slow to react if you have a lot of formulas.