Macro Requested to pull sections based upon number into blank excel sheet

[Darryproduct]

There is a CTR-CAR (Customer Transaction report / Customer accrual report) excel file that has a "CTR" Tab and a "CAR" tab. The CTR tab has a "Rebate No" column and often we have to pull a list of 10 or more rebate ID sections from the CAR report into a blank excel sheet to provide sufficient support for the journal entries we are booking. This takes a lot of time sometimes. The lines in the CTR look like the below:

[TABLE="width: 1336"]
<tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]GL Account[/TD]
[TD]Debit Account[/TD]
[TD]Rebate No[/TD]
[TD]Rebate Type[/TD]
[TD]Rebate Amount / Rate[/TD]
[TD]Description[/TD]
[TD]Effective Start Date[/TD]
[TD]Effective End Date[/TD]
[TD]Prior Month Bal[/TD]
[TD]Current Month Rebate Accrl[/TD]
[TD]Curr month Deductions[/TD]
[TD]Rebate bal[/TD]
[TD]Channel[/TD]
[TD]Comments[/TD]
[/TR]
[TR]
[TD]12301[/TD]
[TD]40309[/TD]
[TD]100121[/TD]
[TD]FA[/TD]
[TD]5833.33[/TD]
[TD]Technoglobal - NT BU - 2017 U - Apr-Jun'17 MDF - $17.5K[/TD]
[TD]16-APR-17[/TD]
[TD]23-JUN-17[/TD]
[TD]0[/TD]
[TD]10000[/TD]
[TD]0[/TD]
[TD]10000[/TD]
[TD]CHLAT1[/TD]
[TD]xxxx[/TD]
[/TR]
[TR]
[TD]12301[/TD]
[TD]40303[/TD]
[TD]100151[/TD]
[TD]FA[/TD]
[TD]333.33[/TD]
[TD]RC WILLEY LNK - NT BU - 2017 - U - O&A - Q3 NP - $1K[/TD]
[TD]1-APR-17[/TD]
[TD]30-JUN-17[/TD]
[TD]0[/TD]
[TD]20000[/TD]
[TD]-15000[/TD]
[TD]5000[/TD]
[TD]CHCEL1[/TD]
[TD]xxxx[/TD]
[/TR]
[TR]
[TD]12301[/TD]
[TD]40315[/TD]
[TD]100312[/TD]
[TD]FA[/TD]
[TD]3090[/TD]
[TD]ABBOUD TRADING CORP - NT BU - 2017 - P - INSTANT REBATE - (MIR 52720) - LNK[/TD]
[TD]10-APR-17[/TD]
[TD]12-MAY-17[/TD]
[TD]50000[/TD]
[TD]0[/TD]
[TD]-20000[/TD]
[TD]30000[/TD]
[TD]CHLAT1[/TD]
[TD]XXXX[/TD]
[/TR]
[TR]
[TD]12301[/TD]
[TD]40303[/TD]
[TD]101007[/TD]
[TD]FR[/TD]
[TD]5[/TD]
[TD]LONDON DRUGS, LTD - CO BU - 2017/2018 - U - O&A 5% INTERNAL MDF[/TD]
[TD]19-MAY-17[/TD]
[TD]18-MAY-18[/TD]
[TD]18252.81[/TD]
[TD]992.30[/TD]
[TD][/TD]
[TD]19245.11[/TD]
[TD]CHCAN1[/TD]
[TD]xxxx[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

The sections of the CAR look like the below:

[TABLE="width: 936"]
<tbody>[TR]
[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: 11"]FUTURE SHOP - CO BU - 2017 - U - O&A APR ENDCAP PROTO 1.0 TABLET ACCESSORIES - $0.7K[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Rebate Number : 101002[/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]
[/TR]
[TR]
[TD="colspan: 3"]Effective Dates : 02-APR-17 29-APR-17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]Rebate Type FIXED AMOUNT GL Asset Account 12301 Accrued Co-op/MDF[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]Sales Type GROSS SALES GL Expense Account 40303 Promotional Funding[/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]
[/TR]
[TR]
[TD="colspan: 11"]Rebate Tiers[/TD]
[/TR]
[TR]
[TD="colspan: 11"]Customer Info 2172[/TD]
[/TR]
[TR]
[TD="colspan: 11"]Product Info .MCP...(I), .MCB...(I), .MMA...(I), .LSG...(I), .TAB...(I), .MSG...(I), .CBL...(I), .AVI...(I), .MPP...(I), .MPW...(I), .SRG...(I)[/TD]
[/TR]
[TR]
[TD="colspan: 11"]Comments SF #86978 ; Prog51259. SF COMMENTS "Please deduct $700 from Rebate ID# 98616 for Belkin Endcap Fee for Proto 1.0 Tablet Accessories Hard Goods - APRIL LOG: 441985"[/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]
[/TR]
[TR]
[TD]Month[/TD]
[TD]Rate %[/TD]
[TD]Sales[/TD]
[TD]Accrual[/TD]
[TD]Adjust[/TD]
[TD]Total Accrual[/TD]
[TD]CM Ded[/TD]
[TD]AP Ded[/TD]
[TD]GL Ded[/TD]
[TD]Total Ded[/TD]
[TD]Balance[/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]
[/TR]
[TR]
[TD="align: right"]May-17[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]700.00[/TD]
[TD="align: right"]700.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]700.00[/TD]
[/TR]
[TR]
[TD="align: right"]Jul-17[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"](515.46)[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"](515.46)[/TD]
[TD="align: right"]184.54[/TD]
[/TR]
[TR]
[TD="align: right"]Dec-17[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"](184.54)[/TD]
[TD="align: right"](184.54)[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/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]
[/TR]
[TR]
[TD="colspan: 2"]Rebate Total[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]515.46[/TD]
[TD="align: right"]515.46[/TD]
[TD="align: right"](515.46)[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"](515.46)[/TD]
[TD="align: right"]0.00[/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]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Right above the Rebate description header there is a highlighted black line and 2 rows below the Rebate Total there is another black line.

Is there a macro that can pull the CARs from the "CAR" tab in an excel file with both the "CTR" & "CAR" tab into a separate blank worksheet where the black lines overlap and are next to each other lined up to down?