Hate to harp on about Lotus123, however it was possible to group
worksheets together so they stayed together unless using a command in
the tool bar. This meant when you formated the first sheet all the
others would be the same, plus most important was that if you went to
say cc200 on one sheet the others would do the same. The advantage was
that we could look at sales data from previous weeks and easily compare
with the current week (simple and quick).

Joining excel worksheets together with control click does not help.

Does anyone know a way to achieve this in excel?

Thanks
Jim