Dynamically link columns between sheets
I am currently working on a project in which we have a large clunky master sheet with various reports and dashboards stemming from it. This has served us to this point but now the master sheet has grown so big it is just unusable and we do not want to continue adding columns to it.
I want to pull/link some columns from the master sheet to another sheet (one in which i can create new columns and show new information based off of the info pulled from the master spreadsheet). This means i cant use a report because it doesn't let me add new columns or new data.
I want the dynamic column sharing of Reporting with the ability to add columns and show new information like with Worksheets. Is this possible?
I have been trying some lookup functions and match functions but have struggled on a multi column bases. Anyone have any ideas?