Joining tables from different worksheets
 

Hi,

I have two spreadsheets with the same structure and I want to find formula to be able to just open these two plus a master spreadsheet and have both sheets 1 on top of the other to make 1 big table in the master spreadsheet.

I cant find a formula that will allow me to do this dynamicly as the size of the tables chage each time the report is run.

I hope this made sence