help. need a formula

[samway301]

i have a spreadsheet with many rows that i need sorted. it looks something like what's below... (there are ~2500 companies in total)

A
[TABLE="width: 500"]
<tbody>[TR]
[TD]Company A[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Address[/TD]
[/TR]
[TR]
[TD]City, State, Zip
[/TD]
[/TR]
[TR]
[TD]Phone[/TD]
[/TR]
[TR]
[TD]Fax[/TD]
[/TR]
[TR]
[TD]Email[/TD]
[/TR]
[TR]
[TD]Fluff[/TD]
[/TR]
[TR]
[TD]Fluff
[/TD]
[/TR]
[TR]
[TD]Fluff[/TD]
[/TR]
[TR]
[TD]Company B[/TD]
[/TR]
[TR]
[TD]name[/TD]
[/TR]
[TR]
[TD]address[/TD]
[/TR]
[TR]
[TD]city, state zip[/TD]
[/TR]
[TR]
[TD]phone[/TD]
[/TR]
[TR]
[TD]fax[/TD]
[/TR]
[TR]
[TD]email[/TD]
[/TR]
[TR]
[TD]fluff[/TD]
[/TR]
[TR]
[TD]fluff[/TD]
[/TR]
[TR]
[TD]fluff[/TD]
[/TR]
[TR]
[TD]fluff[/TD]
[/TR]
[TR]
[TD]fluff[/TD]
[/TR]
[TR]
[TD]fluff[/TD]
[/TR]
[TR]
[TD]Company C[/TD]
[/TR]
</tbody>[/TABLE]

is there a formula that'll copy the data starting with the green text for company name, and put name, address, phone, fax, email onto another sheet? the 'fluff' varies from 5 rows to 20. it's not consistent.

i'm looking for output similar to whats below: (keeping the green text is not necessary)

A B C D E F
[TABLE="width: 500"]
<tbody>[TR]
[TD]Company A[/TD]
[TD]Name[/TD]
[TD]Address (street, city, state, zip[/TD]
[TD]Phone[/TD]
[TD]Fax[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD]Company B[/TD]
[TD]Name[/TD]
[TD]Address (street, city, state, zip[/TD]
[TD]Phone[/TD]
[TD]Fax[/TD]
[TD]Email[/TD]
[/TR]
[TR]
[TD]Company C[/TD]
[TD]Name[/TD]
[TD]Address (street, city, state, zip[/TD]
[TD]Phone[/TD]
[TD]Fax[/TD]
[TD]Email[/TD]
[/TR]
</tbody>[/TABLE]


Thank you in advance.

 

[VBA Geek]

is the 'fluff' actually fluff in the file or does it mean it can be any text?

 

[samway301]

it can be any text. it's text that i don't need copied into the new row.