Code to refresh all tables in Power Query

[Pasadu]

Please I have a sheet with 5 tables from the same source, in Power query. Please I need a code whereby when I upate the maser sheet, ALL the tables on the sheet will be refreshed and updated automatically too. Thank You.

 

[AlanSidman]

ActiveWorkbook.RefreshAll

 

[Pasadu]

ActiveWorkbook.RefreshAll

Thank you sir for the response,but where should I put it? Module or ???
Should I start with private sub or ??

Please I will appreciate it if you could guide me wholly. Thank you.

 

[AlanSidman]

Either put in a module or attach it to a command button.
Regular Sub if not attached to a command button.

 

[Pasadu]

Thank you