Copying data from several worksheets in one new worksheet

Hello again

I'm getting reports in an Excel file with more then 30 worksheets. All of them have the same structure. I would like to add them all in one single sheet and to place the source "sheet name" in the last column.
All sheets have 12 columns with different number of rows (between 1 and 100). First row in each sheet is the header of the table.

It is posible any automatization?

Thanks and regards
Catalin