Adding Sheet Names as a column in a table

Hi forum,

I am reading data from multiple sheets in the same Excel file. Each sheet contains the same columns and differ in the number of rows. Each row represents a Field record. Each sheet name represents an Object name. I have managed to successfully combine all the rows form the different sheets into one table using a loop. However I need the sheet names to to populate in a column within the same table in order to illustrate which Fields records are specific to each Object. Is it possible to do this?