I'm setting up a template worksheet that I need to pull data from other sheets and input into the template. The data will change from one project to the next, including the number of rows of data.

I want to build a macro that initiates when the worksheet is opened. The macro will insert the number of rows necessary at specific locations and then populate the new rows with the new information. Essentially a copy paste with variable data.

Any suggestions on how to proceed?