Hi folks.
I'm not sure if this can be done or not.

I have multiple sheets based on monthly data.
Col A on each sheet has the same Course IDs with each FY Month, Apr - March across the top.
Each time I drop a new month in, it just appends the Course IDs to the bottom of the last one. So I end up with 12 of each course IDs at the end of the year. Is there a way that when we drop a new month in that it merges data? We need all the data in one table to feed another sheet.

If not, is there a way to take the latest sheet only? As that will have the previous moths also.

We could just replace the last one with a new one with the same Filename but we'd like to identify an individual month should an error occur with the data.

Scratching my head - I may be overthinking this!
Thanks