How to update specific links only with a macro?

I have a HUGE sheet with links to around 100 seperate sheets,

ive diabled automatic calculations so it loads faster, ive then created a macro to open a few workbooks at a time and then update the links, however id like to do this in groups so 10 workbooks open, the links in a specific range will update, the workbooks will close, and then another 10 workbooks open, those specific links update etc etc

ive got my coding as per below

Workbooks.Open Filename:= _
"F:\\abc.xlsx", UpdateLinks:=3


Windows("Database.xlsm").Activate

Calculate

Windows("ABC.xlsx").Activate
ActiveWorkbook.Close savechanges:=False

I cannot figure out how to do the updating a specific range.