copying worksheets into same workbook keeping Links

I am using excel 2007,
How do I select 4 worksheets that have links to each other and copy and past them into the same workbook?
Maintaining the links/relationships between them.

I am trying to get 10 sets of 4 works sheets in the some workbook without have to build each set of 4 worksheets each time.

Thanks

Try selecting all 4 sheets.

Right click on one of them.

Select Move or Copy

Select new book or your target workbook and check create a copy.

Hi,

Hold the shift key down and click each sheet tab name.

HTH