Hello, everyone! I am new to this forum and new to VBA. Thank you in advance for your help!

I receive an excel file daily that contains submitted quotes for projects to a customer. It includes all revisions of the quotes, the approval status, the revision, and total for a project. The list contains several thousand projects, and each revison receives a new quote #

For Example:
Quote #	Project #	Revision	Total	Status
59751	2401000140	1	 $25,625.00 	Approved
60258	2401000140	2	 $250.00 	Disapproved
84376	2401000140	3	 $14,552.00 	Disapproved
84644	2401000140	4	 $16,302.00 	Approved
137383	2401000140	5	 $120,585.85 	Approved
175493	2401000140	6	 $146,099.64 	Approved
218551	2401000140	7	 $154,696.12 	Approved
219079	2401000140	8	 $160,797.63 	Approved
270365	2401000140	9	 $165,685.21 	Disapproved

How would I write a Macro to pull in the Total for the latest Approved Revision for a Project, by line, to a another worksheet? Or remove all lines that do not meet this criteria from the recieved work sheet?

Using the above example, I would want this line:
219079	2401000140	8	 $160,797.63 	Approved