Drop down list loop, copy and paste updated values from a worksheet to a new workbook.

Hi, I have never used VBA before.

I am trying to automate a process for which I have created a simple example to get help.

I have a drop down list in Sheet1, Cell "A3" with values 1, 2 and 3.
The values in Sheet 2, Range B3:B5 forms accordingly.
The formulas used in Sheet2 are as follows:
B3: =IF(B4=5,"Base",IF(B4=10,"Scenario 1","Scenario 2"))
B4: =Sheet1!A3*5
B5:*=Sheet1!A3*10

Now what I want is for Sheet1 drop down to run on a loop and the entire updated Sheet2 along with all formats to get copied in a new workbook.

I also wanted the name of the Sheet in the new workbook to be whatever the value is in Sheet2, Cell B3 (Base, Scenario 1 and Scenario 2).

This is a recurring activity with much larger data and I could really use the help of a VBA code.