Pulling Up Data From Multiple Workbooks

I was hoping you would be able to share your expertise on a problem i am having.

1. i need to consolidate different sets from multiple workeets into a single worksheet - so i can use a pivot table to chart data for a dashboard.
2. i haven't seen any way to do this in the manner in which i require - ie.
-- go to sheet 1... select all data in the sheet (until the last row)
-- THEN go to the next sheet... etc.
-- also i want to make sure the sheets are not continuously deleted as it might ruin the charting function from the pivot tables(?)

Any advice - would be most appreciated

Best,

This is super awesome - !

if it possible to rearrange it so the column length is also dynamic?

Also...

when i create a pivot table from the summary sheet - and try to run the marco again (ie. to simulate data refresh) the macro doesn't work?

it might be because the macro is pulling data from the pivot table as well - is it possible to restrict the macro to only run on the three sheets (forecast, actuals, benchmark)?

i.e. see updated spreadsheet

Originally Posted by MarvinP

Hi,

The macro starts from the left most sheet and works to the right. The summary sheet needs to be the first one on the left.

Try putting your pivot table on the Summary sheet and off to the right and not on row 1. See if that helps.

no - luck!!

any other thoughts?