Combining Two Workbooks/Organizing It

This is a VBA question, so it has been moved to the correct forum.

A button that shows one set of sheet tabs and hides others? Simple enough:

Option Explicit

Sub ShowFirstSet()

    Sheets("Sheet1").Visible = True
    Sheets("Sheet2").Visible = True
    
    Sheets("Sheet3").Visible = False
    Sheets("Sheet4").Visible = False

End Sub


Sub ShowSecoondSet()

    Sheets("Sheet3").Visible = True
    Sheets("Sheet4").Visible = True
    
    Sheets("Sheet1").Visible = False
    Sheets("Sheet2").Visible = False

End Sub

Adjust that as needed and as many as needed. Remember to always SHOW the tabs first, then hide the rest.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Why not just copy all the worksheets from one workbook to the other and colour the tabs so that the worksheets are visually separate but in the same workbook.

In one of the workbooks select all the worksheets, right click on the selected tabs and click on Move or Copy, select copy (to leave the workbook as is in case something happens in the process) choose where to put the copy in the other workbook and click ok. The selected worksheets will be copied to the other workbook. Then just colour the tabs to make those copied worksheets stand out.

They are trying to manage how many sheet tabs there are visible at any one time to minimize scrolling. 60 tabs is a lot.

You can't HIDE all the sheets first as that might create a scenario where ALL the sheets were trying to be hidden at once. So you must unhide at least one sheet at the start. But you can hide and unhide the rest of the sheets in any manner you want.

Also, the macro technique I showed will be relatively instantaneous. When you click the button all 60 sheets will update visibility pretty fast.