Sorting on worksheet with multiple pages

[Ken]

I have a worksheet with headers and footers, consisting
of multiple pages with three columns. I want to sort the
rows by a single column; it works fine on the first page,
but when I add data to the second page and sort the data,
it moves everything to the first page, including what
I'll call a title row separate from the actual header.
Can I accomplish this and still keep the "title" row
(Title row contains the name for each of the three
columns.), or, do I need to eliminate the footer and just
run with the rows continuously?

Thanks,

Ken