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