I have multiple worksheets, each of which is the same table but with different data for different sets. (Each has identical columns and types of data within the columns).

I want to have a sheet in my workbook that will go through and list everything from all of the sheets. Is there a decent way of doing this without writing code or manual copy/paste of everything? Lastly, would it be possible to have a column added to the master sheet to identify which worksheet that line came from?