Hire an Excel Expert

We would like to reformat the layout of an existing excel document to allow for A4 portrait printing. In addition to this, on the Summary Page, we would like to add a Macro that will enable us to insert new Tabs along the bottom (named VAR-00***) etc, and a Macro that will add a new line item into the into the list that includes a hyper link to the relevant tab. The tabs named VAR 00** etc need to be able to have a new rows added easily that wont disrupt the rest of the layout with the workbook. The summary page is set at A4 portrait, but the other tabs are all Landscape and we would like these to be Portrait - this may mean that some of the breakdown boxes will have to be moved. The tables need to be the same size (sitting on top of each other) and the font/typeface needs to be the same throughout the workbook.