Is it possible to have Named dynamic ranges for a worksheet included in
formulas in another worksheet; but have the formulas automatically add rows
of more formulas for each row found in the source worksheet?

I find that I simply have to replicate formulas a good swath of rows to
ensure that all source data rows are calculated while using many IF
statements to prevent empty rows of the source data worksheet from appearing
as zeros in the formula worksheet.

I have variable rows on the source worksheet where the header row is on row
3 and the formula worksheet has the header row on row 1.