Write Macro to copy specific hidden tab based on cell value and rename new tab based on a cell value

I don't know if this can be done- I certainly do not know how to do it. I would like to enter information on the shaded area of sheet1 from a program. That information will give me specific form numbers by checking the 'current' sheet. I have tabs in yellow that match the form numbers. I would like to make a macro that copies the E form sheet corresponding to sheet 1 columns Q R S T U, and renames them to match Prop. line on D6 to D345. I would also hide the E tabs to only show the new Prop. line # for tabs. I there was a link to click on sheet1 to jump to that tab, even better. Also if it would be possible to create a column on sheet1 that shows the total from the new tab to compare on sheet1 that would be amazing. I have tried to find information to help me do this but it is never quite the same as what I am doing.