Every month several employees fill out a form that contain all their expenses for the month.

Expense Detail - Category - Expense Amount

I want to be able to take each form and import it into a master file.

The file would contain a master worksheet that would contain all the tables for each expense report merged into one table.

If John's expense sheet contained 10 expenses (rows of data)
and Mary's contained 17
and so on..

I want mastersheet to list John's expenses; 10 rows (a2-a12). And then list Mary's expenses starting where John left off (a13 - a30)

I want to be able to analyze the data afterwords, but i'm currently having trouble compiling it in one sheet automatically.

This can be done via copy/paste, but i want it to be automatic.

That means if i were to add something to Mary's list, it would automatically compile in mastersheet.