Combining multiple access tables

Hello! I have an Access database with 76 linked tables. All tables have the same number of columns (originally 76 but I chose 45 when I created the queries). I was trying to merge these into one master table by using union query. Unfortunately, I am getting an error when trying to paste the codes when I choose the SQL view. It appears there's too many codes and I am unable to paste everything. Is there a way I can combine all these tables into one using a VBA code or a different query? I only know basic MS Access and I have limited knowledge on these stuff. Thanks in advance

It says "The text is too long to be edited"

I was thinking of using the append query but I realized that it might not reflect the changes on the linked tables. I am not sure how to get all those tables combined, and also making sure all the updates on the linked excel tables will be reflected...