Formula to filter data to a new sheet?

[revdanuren]

Sheet one contains data with range titled "Expenses"

[TABLE="width: 285"]
<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>[TR]
[TD="class: xl65, width: 64, bgcolor: transparent"]Line Item[/TD]
[TD="class: xl65, width: 105, bgcolor: transparent"]Line description[/TD]
[TD="class: xl65, width: 121, bgcolor: transparent"]Vendor[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]Date[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]22129[/TD]
[TD="class: xl65, bgcolor: transparent"]Benelovence[/TD]
[TD="class: xl65, bgcolor: transparent"]Walmart Grocery[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]4-Dec[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]22129[/TD]
[TD="class: xl65, bgcolor: transparent"]Benelovence[/TD]
[TD="class: xl65, bgcolor: transparent"]Buy For Less[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7-Dec[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]51892[/TD]
[TD="class: xl65, bgcolor: transparent"]Misc[/TD]
[TD="class: xl65, bgcolor: transparent"]Hilton[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7-Dec[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]51892[/TD]
[TD="class: xl65, bgcolor: transparent"]Misc[/TD]
[TD="class: xl65, bgcolor: transparent"]Hobby Lobby[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1-Dec[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]60150[/TD]
[TD="class: xl65, bgcolor: transparent"]Worship[/TD]
[TD="class: xl65, bgcolor: transparent"]Amazon[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]11-Dec[/TD]
[/TR]
</tbody>[/TABLE]


On sheet2 I want the results to look like this

[TABLE="width: 280"]
<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>[TR]
[TD="class: xl65, width: 111, bgcolor: transparent"]Line Item[/TD]
[TD="class: xl65, width: 105, bgcolor: transparent"]Line description[/TD]
[TD="class: xl65, width: 94, bgcolor: transparent"]Vendor[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Date[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]51892[/TD]
[TD="class: xl65, bgcolor: transparent"]Misc[/TD]
[TD="class: xl65, bgcolor: transparent"]Hilton[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]7-Dec[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]51892[/TD]
[TD="class: xl65, bgcolor: transparent"]Misc[/TD]
[TD="class: xl65, bgcolor: transparent"]Hobby Lobby[/TD]
[TD="class: xl66, bgcolor: transparent, align: right"]1-Dec[/TD]
[/TR]
</tbody>[/TABLE]



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