Is there a way to add rows automatically given a number of values another sheet has?

I have an issue where an invoice is being consolidated with a total price, but I need to break that invoice out by multiple rows for each project that is in that invoice.

For example, on Sheet 2 where invoice 1 has projects 1-6, I?d need Sheet 1 to have 6 rows as well with each project?s value listed, instead of one row with the total invoice value of $66,249.

Is there a way to create a macro or formula to create X amount of rows given the number of projects an invoice has on sheet 2?

Thanks!