Insert rows/create tables based on user input?

I am creating a bid worksheet for my company. For certain jobs, we require more crews on site than we do for other jobs, so our number of crews needed changes per job. How can I input a crew cost table based on the number of crews needed for the job? I have attached my table so far for reference.

Basically, I would like to create a number of tables (A7:J16) based on the number entered into C5 with a one-row space between tables.

Also, would there be a way, once multiple tables have been created, to add the "Crew Total" cells and SUM(X,Y,Z) them into another cell?

Something like this?

Attached file for reference.

Named ranges
CrewNum ='Labor and Equipment'!$C$5
TableCopy ='Labor and Equipment'!$A$7:$J$16
TableTotalCopy ='Labor and Equipment'!$I$16:$J$16

Please Login or Register  to view this content.

Yeah, I wouldn't mind the button. However, the code didn't work (at least on my machine). I enter a number and click Generate and nothing happens.

Did you put a number greater than 8?

I'm working on the assumption that you can have 8 crew members per table.

If not, and you want the number there to be the number of tables then... delete the line in red below.

Please Login or Register  to view this content.