Automate a Import Process/Maybe just a Refresh

[TCB1]

I’d like to try and automate a import process. Below are the steps I currently use to get these excel spread sheets into my ms access database.

Manual delete tables Table1, Table2, Table3, Table4.
Open the macro to TransferSpreadsheet exel TableA
Open the macro to TransferSpreadsheet exel TableB
Open the macro to TransferSpreadsheet exel TableC
Open the macro to TransferSpreadsheet exel TableD

“All these tables have the same type of data, and field names”

Run append query to Master_Append_qty for all 4 Tables.

Is there a way I can just do a refresh. All

Can I get some advice or help automating this process

Thanks for all your help and time
TCB

[olivthill2]

There are DoCmd.Requery, or Me.Repaint.

Perhaps you don't know how to call a macro from another macro.
You call it with call ...

You might need also DoCmd.OpenQuery ... or DoCmd.RunSQL ...