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:

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

<tbody>
</tbody>

The sections of the CAR look like the below:

FUTURE SHOP - CO BU - 2017 - U - O&A APR ENDCAP PROTO 1.0 TABLET ACCESSORIES - $0.7K
Rebate Number : 101002
Effective Dates : 02-APR-17 29-APR-17
Rebate Type FIXED AMOUNT GL Asset Account 12301 Accrued Co-op/MDF
Sales Type GROSS SALES GL Expense Account 40303 Promotional Funding
Rebate Tiers
Customer Info 2172
Product Info .MCP...(I), .MCB...(I), .MMA...(I), .LSG...(I), .TAB...(I), .MSG...(I), .CBL...(I), .AVI...(I), .MPP...(I), .MPW...(I), .SRG...(I)
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"
Month	Rate %	Sales	Accrual	Adjust	Total Accrual	CM Ded	AP Ded	GL Ded	Total Ded	Balance
May-17	0.00	0.00	0.00	700.00	700.00	0.00	0.00	0.00	0.00	700.00
Jul-17	0.00	0.00	0.00	0.00	0.00	(515.46)	0.00	0.00	(515.46)	184.54
Dec-17	0.00	0.00	0.00	(184.54)	(184.54)	0.00	0.00	0.00	0.00	0.00
Rebate Total	0.00	0.00	515.46	515.46	(515.46)	0.00	0.00	(515.46)	0.00

<tbody>
</tbody>

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?