live data from multiplue workbooks into 1

[mbaughuk]

I have 11 workbooks that I need to view in 1 book

what I have are 11 depots and each of the workbooks all look the same but on the tab that says the 2nd Tier weekly I would like to view all work books in 1 so that I don't have to view all of the separately

is there a way of doing this

thanks

Coventry 2014.xlsx

[FDibbins]

I would like to view all work books in 1

Do you mean all WB's on 1 sheet in a "master" WB, or each WQB on its own worksheet in a "master" WB?

Perhaps if you could show a sample of what you want?

[mbaughuk]

What I need is all of the workbooks have a tab called 2nd tier weekly I want that tab from each on a master tab

hope this make sense

thanks

Marcuss