Auto resizing worksheets to display correctly on different screens

Hi Lorenzo, thank you so much for your reply and assistance, I tried your code and it did what you said it would do, but wasn't exactly what I needed.

I have created a worksheet that has command tabs that link to other sheets with relevant information (as per picture) and was wanting the sheets to automatically"fit" whatever screen that they are opened on (e.g. if you open the worksheet on an ipad it is the correct view, if you then open the same worksheet on a laptop it is the correct view and so on).