Hi all!
first time posting so I’m excited to see what can happen!
I’m looking to speed up a process within my work place by creating a ‘summary page’ which puts all the data we’d need to see on one worksheet.
So, say I have 5 sheets in one workbook, titled ‘summary’, ‘table 1’, ‘table 2’, ‘table 3’ & ‘table 4’.
On my summary page, I’d like to put ‘table 2’ in a cell then see all the information in the sheet ‘table 2’ populate on my summary page. And if I change that cell to say ‘table 4’, all the content within the ‘table 4’ tab would populate instead.
does this make sense to anyone? If it’s possible to do as a formula I’d really appreciate some help writing one. I am open to VBA, however my knowledge of it is that of a 10 year old.
thanks in advance!
