I assume by "spreadsheets" you mean "worksheets" not "workbooks"?

I don't know what you mean by "I have had to setup navigation buttons for
each tab ..." Why? What's stopping you just defining a single set of
navigation buttons outside your MultiPage control (presumably below it, at
the bottom of the form)?

What specifically have you tried, that has failed? And what errors are you
receiving?