I have an excel spreadsheet with, say, 5 worksheets where I'm entering data in basic table form = A1-K1 contains my headers, each row below contains data, on a regular basis I am adding data to the bottom-most empty row, so maybe today there are 4 rows of data, tomorrow 6, etc., and I am doing this across all 5 worksheets all with the same headers.
What I want to be able to do is combine all this data in a new sheet, so basically be pulling from row 2 until "last row with data" in each sheet, with ability for it to be updating dynamically so as I'm adding new rows to each individual sheet, the "combine" sheet gets longer and includes said new rows. I don't care what order the data is in on the "combined" sheet.
I've added an attachment that is a sample version of what I'm looking to do to help clarify.
Is this possible? I've considered some kind of offset formula but I can't figure out a way to pull dynamic ranges from multiple sheets into one and I'm not strong with VBA which I'm guessing might be the only way to do this.
Bookmarks