Need macro to open, refresh, save, close 50 workbooks in a folder.

Hello all, I'm new to VBA and writing macros, but have set up a project where I've 50 workbooks, all with live data feeds from Bloomberg, in a folder. For the feeds to be updated, the workbooks must be opened, refreshed, saved, and then closed. I need a macro that would automate this task for all 50 workbooks, but my current macro saves and closes the books before they get a chance to update. I tried working with a time delay, but this seems to pause ALL Excel calculations/operations.

Any help would be greatly appreciated.

No pivot tables involved. Bloomberg has an Excel add-in, where you can type 'bloomberg formulae' into cells and it pulls in data off its servers