Append data in one table

Hi everyone

I have as raw data the three tables with a "00_" prefix. I want to process my data in three different steps with three different tables or queries:

01_UNIFIED TABLE:
All of the tables are appended in one single table or query, keeping the source table as a field for the data

02_RESULT TABLE1:
It focuses on Colors from the UNIFIED TABLE. There is only one Color per line, and its corresponding Supplier, InternalCode and SourceTable.

03_RESULT TABLE2:
It deletes duplicated records from RESULT TABLE 1 and keeps only Food, Color and InternalCode columns.

Does anyone know how I can do this? Either with queries or with VBA

Thanks!

I often have tables that exceed the copy-paste limit from excel (65,536 cells). Since I want this process to be automatic, unfortunately this solution does not work for me

It works but the database I am handling has too much data, too many tables with many columns, not always the same. I took your solution and adjusted it to what I have and unfortunately I get an error that says "Query is too complex" :/

The query has a limit of 50 SELECT procedures for a SQL code. The schema might be faulty, but the Access file comes directly out of a software with the information stored in this way and I have to work with it.