Sort entire Rows to different tabs based on one cell of information.

[aworral]

Hello,

I need to create a sheet that that will have a general tab for entry, but it would then sort and send an entire
row of data to another tab based on the information of one cell. I realize that it is close to a vlookup, but don't know how to make a vlookup to apply to the entire row (not the entire row, maybe 5 cells out of the row).[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Example[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Account[/TD]
[TD]$[/TD]
[TD]Stage[/TD]
[TD][/TD]
[TD]Account[/TD]
[TD]$[/TD]
[TD]Stage[/TD]
[TD][/TD]
[TD]Account[/TD]
[TD]$[/TD]
[TD]Stage[/TD]
[TD][/TD]
[TD]Account[/TD]
[TD]$[/TD]
[TD]Stage[/TD]
[/TR]
[TR]
[TD]Smith[/TD]
[TD]$100[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]Smith[/TD]
[TD]$100[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]Jones[/TD]
[TD]$200[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]Kelley[/TD]
[TD]$[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Jones[/TD]
[TD]$200[/TD]
[TD]2[/TD]
[TD][/TD]
[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]Kelley[/TD]
[TD]$150[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

I hope this makes sense, first time using this board. Thank you in advance!!!

Allen Worral