Macro to create sets of tables based on number input

Hi,

I'm working on creating a calculation sheet to find the pressure drop in various branches of pipe.
Branches Sheet contains a couple basic inputs. The main thing is the number of branches.
Liquid Branch Template Sheet contains the branch format I'd like for each branch.
Pipe Data Sheet just has formula and sizing information.

I've never made a macro before, but I'd like to be able to input "Number of Branches - 5" and have a new sheet created with 5 copies of the Liquid Branch Template, labeled Branch 1, 2, etc.

Does anyone know of a good video or tutorial that'd show me how to accomplish this?


PipeTest.xlsx


Thanks!