I have an interesting project to work on and I am not quite sure what
the best method to attack it would be.

I have two sheets.... 'Footages' and 'Breakdown'

Footages is a general line item description with footages for each
floor, with the floors laid out in columns starting with 1 thru X

Breakdown pulls the description and the total footage from the
Footages sheet.

What I need to do is dynamically create line items in the Breakdown
sheet per floor. Example: If I enter on the Footages page, Wall Type
A, with 100 feet on each of the first 3 floors, I have 300 total feet
for Wall Type A but on my Breakdown sheet I need it pull the total
line, then recognize something in the 1st floor column and add a line
item below the total and do the same for the 2nd floor, the 3rd floor,
and so on...