Automatically updating a summary sheet

Hi

I'm new here, and I hope someone can help. I have a large excel workbook with a number of sheets that all feed information into a simple summary sheet.

Occaisionally, I will add an extra ROW into one of the feed sheets, but cannot get this to show on the summary sheet without manually inserting a row and dragging the first row down to autofil etc.

For example, my summary sheet will display information but the code is

=Fleet!B7
=Fleet!B8

The Fleet feed sheet is a few lines long, but if I add a row between B7 and B8 it isn't picked up on the summary.

Why is that and how can I get round this?

Thanks.