VBA Performance Tuning on Formulas - Help!

Hello - I have a worksheet that has a data validation (eg. north, south, east, west). And below that is the calculated data which is populated based on the selection above and master data. Note that the master data is in another sheet, so the filter is using formulas. I have close to 100 such columns in the calculated data which is pulled from other tabs.

Now,in order to consolidate this calculated data (add a data validation value "ALL" ) I have a VBA which does the following:

a) Loop through the each value in data validation.
b) Data gets filtered
c) Copy the range to another sheet.
d) Next and so on append in a temp sheet.

This temp sheet now has all the calculated data and I am referring back in the main sheet by using the filter ALL.

This whole process of copy takes 1 min 30 sec to process because of the formulas. Please advise if I can use an alternative process or if it is normal to take this long when looping on formulas.

I cannot change the workbook, as the user needs to see by region data on the main sheet as well consolidated using the data validation list.

Regards,

I cannot turn the calculation mode to manual, because each time the vba auto selects the value from data validation list ( drop down), it filters the data and I need to copy this filtered data to another sheet.

Attached is an example I created to show how the workbook looks like.