Update an Exsiting Excel Macro

I've a rather complicated looking Excel Macro which needs updated. Essentially, we use Google Form to collect information, and run the Excel spreadsheet of data through a Macro to come up with a much better looking format. In Google Sheets, connected with Google Form, all the data gets recorded horizontally. That's hard for us to read, so we use an Excel Macro to convert that Horizontal Data in Vertical (Transpose, in a way). So, it becomes much easier. We added some new pages to Google Forms, and thus our old Macro is no longer valid. We had 10 pages of information, now we have 30 pages of information. We need to update an existing Excel Macro, find out errors and make it work. I've uploaded Dataset, Macro & Output to see how it works.