I have multiple Workbooks with multiple Worksheets and Charts in each. Right
now I have a central worksheet with a bunch of Command Buttons with Macros
that navigate around these sheets and charts.

I want to develop a Form (?) to navigate to Workbook1Sheet1,
Workbook2Chart3, etc. For example, choose Workbook 1, then get the
sheet/chart choices within that Workbook. I would like to return to this
central location when the requested sheet/chart is closed.

What is the best way to develop a form that navigates like this and also
allows you to return to the central location?

Thank you for your help.