Refresh menu.
If the refresh button is pressed the order of updating the sheets Is following:
1. The sheets starting with “Data_”
2. The sheets starting with “Web_”
3. The sheets starting with “Pivot_”
You can also update only the sheets starting with “Data” by selecting the Data from Refresh menu.