Making Size of Named Ranges Adapt

I have an input worksheet into which I occasionally need to insert or delete rows. Any range defined in this sheet grows or shrinks accordingly, which is fine. However, on another sheet that reads from this input sheet, existing named ranges or defined ranges do not grow or shrink to match, so fomulae elsewhere that require ranges to be of the same size fail as soon as I add or delete rows on the input sheet. How can I make ranges on the related sheet grow or shrink automatically to match the input sheet? If this is not possible, how do I assign a fixed size to ranges and named ranges that will not respond dynamically?

Neither! Yes, it's the school holidays again!!!

The workbook is complex and full of sensitive data, so I can't easily provide an example, but here's how it works:

1. Worksheet A is the input sheet. Range $A$4:$A$200 is used in formulae on different sheets. This dynamically changes if I insert or delete a row. So far, so good.
2. Worksheet B draws data from worksheet A and other worksheets, and it has named ranges (e.g. Gender) that correspond in size to the range mentioned in Worksheet A, but these named ranges do not grow and shrink when I add or delete rows in Worksheet A, even though the data in that sheets appears as it should.
3. Worksheet C contains formulae (e.g. COUNTIFS) that require the ranges defined to be the same size. These ranges are drawn from Worksheets A and B. Because of 2 above, as soon as I do 1 above, the formulae in this third sheet fail.

How do I make the ranges or named ranges in Worksheet B grow or shrink when I add or delete rows in Worksheet A?

Thanks, John. Are you suggesting that I use these to define the named ranges?

Thanks, Pete. I think I will go with your solution. I'm currently away from my PC, but will try it later.