report/page/column titles. *Any ideas?

Here's one idea:
~ Make a backup copy of your file to avoid losing data!
~ Insert a new column A and starting at the top of your file, number
each row. (You can do this by typing 1 in cell A1 and the putting the
formula =A1+1 in cell A2; copy that down for all 500 pages; then
highlight column A, copy, and "paste special as values" back over
itself so what remains is the numeric entries only, no formulas.)
~ Sort all the rows in such a way as to group all the header rows
together- do this by choosing a column that is unique to the header
rows. For instance: choose a column that contains only numeric data,
and sort it alphabetically: all the text rows- the headers- will be
grouped together, and all the data will be separate.
~ When all the header rows are grouped, delete those rows.
~ Sort all the rows on column A, the row numbers you added, to get the
data back to its original order
~ Delete column A

Dave O
Eschew obfuscation