Tables on separate sheets. Want to Display All Data in one Table

Hi,

I have some tables; they area all on different sheets. I would like to consolidate them into one master table. Each table will always have the same number of columns, but some rows will be blank. I have named each table and have a list of table names that i named. I thought having a named range of the table names would help me figure this out, but i am still stuck. I have managed to be able to display the data of Table1 using this formula entered in A2 on the master table sheet.

=OFFSET(Table1[Column1],0,0,COUNTA(Table1[[Column1]:[Column1]]),1)

However I am having trouble on how to formulate this across all the tables so that i get a continuous list of all the entered information.
Any help is greatly appreciated!Thank you!

try to upload with sample workbook for clear explanation

Here is a sample workbook. I hope it is clear what I am trying to do.

Originally Posted by NoExcelSkills17

Here is a sample workbook. I hope it is clear what I am trying to do.

Did you ever figure this out?

Pls see the file attach, hope this helps

@ Lotrking1010 No. I just decided to change the way i was organizing my data. Since all of my tables have the same column headings it actually wasn't necessary to do what i was trying to do. Instead i just added another column that would allow me to sort and filter by "Period". It would be hard for you to see since this is just a dummy sheet, but my actual sheet was calculating items based on the sheet name where the tables were located. Anyway i just re organized some items and changed formulas and now i am much happier with keeping a larger single table.