Formula to filter data to a new sheet?

[revdanuren]

Sheet one contains data with range titled "Expenses"

Line Item	Line description	Vendor	Date
22129	Benelovence	Walmart Grocery	4-Dec
22129	Benelovence	Buy For Less	7-Dec
51892	Misc	Hilton	7-Dec
51892	Misc	Hobby Lobby	1-Dec
60150	Worship	Amazon	11-Dec

<colgroup><col width="64" style="width: 48pt;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3726;"> <col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4295;"> <col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3157;"> <tbody> </tbody>

On sheet2 I want the results to look like this

Line Item	Line description	Vendor	Date
51892	Misc	Hilton	7-Dec
51892	Misc	Hobby Lobby	1-Dec

<colgroup><col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 3953;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3726;"> <col width="94" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3328;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>

I can accomplish this with an advanced filter but I have to rerun the filter each time I add data to sheet1. I would like a formula that keeps a running sheet of this. I tried vlookup and it only returns the first row and stops looking. I looked into index and match but again those did not seem to accomplish what I want. I want it to autopopulate sheet2 when I input data on sheet 1 Is there a way to do this without VBA?

I know there is a simple solution I am overlooking and have spent 2 hours searching through forums and other formula suggestions but am unable to locate exactly how to extract data based on one criteria to a new sheet. Thank you