How to use 5 sheets in a master sheet?

[nkarlsvik]

I wonder if there is a way to put entire sheets(with scrolling function) into another sheet?

I have 5 sheets, each showing data of the wereabouts of one particular ship from the entire year, based on week nr.

I want a master sheet that has 5 `windows`, the windows beeing the other sheets in the workbook. I want to be able to scroll these windows to see the entire year, but without having to open up each of the 5 sheets showing the full data.

really need help.

/Nic

 

[JimM]

Try

Window > New Window (repeat 4 times)

Window > arrange > tick the Tiled and Windows of active workbook options

You can then click in each window and select the appropriate tab

HTH

Jim

 

[nkarlsvik]

Yes, altough this might be a temporary solution, it is definitly not ideal.
What im looking for is a feature in excel that alows me to merge sheets into another.