Hi,

I currently have 1 extract from sharepoint that 6 different departments are using to create multiple reports by adding department specific data and then creating pivot tables/charts. I would like to just take the 6 departments files and copy the relevant values into the main extract so that I can create all pivots and dashboards from a central locations at once. My goal is to create one data source and then use power pivot for my charting needs. Is there just a general vba script that I can use for this purpose? I'd like to create a macro that can automate this function vs. manually performing this task each month. Any assistance that can be provided would be greatly appreciated.

Thanks!