Excel 2003.
A report has in col A, 4 Headers (or segment titles) for the report which is
in 4 parts, in Sheet1. Also data is in Col A below the 4 Headers. Also in
Col E is data that corresponds with the labels in Col A (on the same rows).
However the report does not come thru with the 4 Headers/segment titles in
the same row in Col A all the time, it varies. Also the data shifts rows,
and is not in the same place all of the time.

I wanted to rearrange the data so that it is in the same rows/cells all of
the time, by linking them to a different tab in the same workbook, Sheet2.
That way all of the Headers and data are in the same place each time on
Sheet2.

I have tried Vlookup, Match, Mid, Hlookup, Offset, and everything else but
it will not bring the 4 Headers and data from Sheet1 to Sheet2.

The 4 Headers have the same title text in them each time. So I tried to key
off of that via Offset and everything else, but was not successful.

I want to rearrange the data so that it will be automatically charted ever
time, via links to Sheet2.

Sheet1 layout below.

Col A Col E

Header1
Data1 Other Data1 in Col E

Header2
Data2 Other Data2 in Col E

Header3
Data3 Other Data3 in Col E

Header4
Data4 Other Data4 in Col E

Thanks for your expert help.
--
Rick