I've seen other threads regarding similar questions, but not specifically to the approach I'm attempting to take.
I have one workbook with 15 sheets, the first 14 are three column lists of up to 200 entries. I'd like to make the last sheet a dynamic list of all of the 14 previous sheets, so that if a record is added to the sheets with data, it is automatically updated on the combined sheet. I can format with tables, or without, it doesn't have to be a specific formatting.
Any help is appreciated.
I have one workbook with 15 sheets, the first 14 are three column lists of up to 200 entries. I'd like to make the last sheet a dynamic list of all of the 14 previous sheets, so that if a record is added to the sheets with data, it is automatically updated on the combined sheet. I can format with tables, or without, it doesn't have to be a specific formatting.
Any help is appreciated.
