Extract data from separate worksheet

[searnold56]

First, apologies for vagueness as I don't really know how to approach this.

I am exporting reports that are providing customer info that I need to consolidate into single lines. Unfortunately, the export is designed in a pdf/printable report format. The objective is to copy updated data into an input worksheet that then reformats the customer information in single lines that I can filter to create follow-up activity. There is both a header and footer on each "page" which I will try to represent below.

Notes:

• Each "page" has 8 rows on top (shown below) with the report name, business name, and address, customer type, then header row.
• Each "page" has 4 rows on the bottom, 3 blank and 1 with the printed time/date and page # of #
• Customer detail is framed in 5x20 sequences, but periodically the customer type changes so the number of customers per page is not consistent.
• Each 5x20 customer block is the same, except swap out the phone type (ex: cell could be home, the blank cell between and some cells may be blank. Ideally my consolidated row returns a blank value if the cell is blank.

[TABLE="class: grid, width: 0"]
<tbody>[TR]
[TD="colspan: 3"]Report name[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxx[/TD]
[TD="colspan: 9"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxx[/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxx[/TD]
[TD="colspan: 4"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxx[/TD]
[TD="colspan: 4"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]xxxxxx[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"][/TD]
[TD="bgcolor: #d3d3d3"]XXXXXX[/TD]
[/TR]
[TR]
[TD="colspan: 4"]Customer Type: Sample[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Customer[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Contact Information[/TD]
[TD][/TD]
[TD="colspan: 3"]Activity[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Balances[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Last Payment[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Last, First[/TD]
[TD][/TD]
[TD]Cell :[/TD]
[TD="colspan: 2"]123-456-7890[/TD]
[TD="colspan: 3"]First: 05/19/2016[/TD]
[TD][/TD]
[TD]Services:[/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]05/14/2019[/TD]
[/TR]
[TR]
[TD="colspan: 4"]123 Main St[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]City, ST zip[/TD]
[TD]Work :[/TD]
[TD]123-456-7890[/TD]
[TD][/TD]
[TD="colspan: 3"]Last: 06/18/2019[/TD]
[TD][/TD]
[TD]Discount:[/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$185.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Email :[/TD]
[TD="colspan: 2"]email@example.com[/TD]
[TD="colspan: 3"]Next: 06/27/2019[/TD]
[TD][/TD]
[TD]Account:[/TD]
[TD]$0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Printed:[/TD]
[TD="colspan: 4"]Wednesday, June 19, 2019 9:33:50 AM[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Page[/TD]
[TD="align: right"]1[/TD]
[TD]Of[/TD]
[TD="align: right"]332[/TD]
[/TR]
</tbody>[/TABLE]

I would like to return data under these headers
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Email[/TD]
[TD]Cell[/TD]
[TD]Work[/TD]
[TD]Last Activity[/TD]
[TD]Next Activity[/TD]
[TD]Account
Balance[/TD]
[/TR]
</tbody>[/TABLE]

While a direct answer to this is welcome, even suggestions as to functions I should be looking into would be terrific.

Thank you!

 

[searnold56]

Bump