Access - merging tables monthly

Hi

I need to be able to merge tables monthly, into one big table, and identify any duplicates.

I have currently a table of data, with the same column headings, one for each month this year.

I need to merge these.

Then I'd like to create some code or macro, to automatically add new tables each month, and again look for duplicates.

I then need to create some stats based on the data within the mass data, but I think I can do that, from my course notes.

ie some of data for a certain code

No of items that are less than less than 500 shown in green
those between 500 and 2500 in amber
those greater than 2500 in red

does that make sense?

I'd then like to see the breakdown of those 3 figures (by double clicking)?

Best wishes,
many thanks
Clair