@vletm
Yes #5 has a dropdown that I am using which is a form control. I need to filter my pivot based on that. Previously I had share a list box created in data validation.
I want to download four file from sharepoint, consolidate and paste them in excel. Run calculations and refresh pivots. Then delete unwanted tabs and upload back to sharepoint