ListObject QueryTable Refresh

I have a Workbook that has several tables linked to an access database.

I am trying to write a macro that will update all of these tables.

I can successfully update a table using ListObject.QueryTable.Refresh BackgroundQuery:=False

However what I am looking at doing is updating all of the tables without the macro having to select the sheets on a time delay.

Currently I am using an ontime command between table updates.

Is there a way to make it update all tables in sequence?

*for all tables in wkbook update tables one after the other*

Current I have a block like this:

Please Login or Register  to view this content.

However I want to avoid using select and also avoid using time delays and just have one start updating as the previous one finishes.

Can anyone help with this?