Moving Rows of information to a separate sheet in Excel

[1001Veyron]

Alright, so I'm really rather new to this VBA thing and I've been doing some research and digging and I can't seem to be able to use anything that I find online to help me with what I need. I've tried changing some code around and nothing seems to work, so I am hoping someone on here could help me. I would like to take a row of information and completely move it to a different sheet in the same workbook in excel based on a certain criteria in one of my columns. If my column "T" has a "Y" in it, then I would like to have that column moved to a different sheet, then have the original line deleted and the rest of the rows moved up one. Would anyone be able to help me with this? My sheet looks something like this...

[TABLE="width: 1303"]
<tbody>[TR]
[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]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]S[/TD]
[TD]T[/TD]
[/TR]
[TR]
[TD]ROW 3[/TD]
[TD][/TD]
[TD]TORDET 01[/TD]
[TD][/TD]
[TD]DATE: 2014 03 24[/TD]
[TD]17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Broker[/TD]
[TD]Waybill #[/TD]
[TD]Entry[/TD]
[TD]Barcode[/TD]
[TD]Pkgs[/TD]
[TD]Other[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]321[/TD]
[TD]0313VVJXF7H[/TD]
[TD][/TD]
[TD]*0313VVJXF7H*[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]321[/TD]
[TD]05WV95THCPH[/TD]
[TD][/TD]
[TD]*05WV95THCPH*[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]321[/TD]
[TD]E635X43ZVSK[/TD]
[TD][/TD]
[TD]*E635X43ZVSK*[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]321[/TD]
[TD]H9206474021[/TD]
[TD][/TD]
[TD]*H9206474021*[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD="align: right"]1[/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]321[/TD]
[TD]6638W4PHPRW[/TD]
[TD]AQI[/TD]
[TD]*6638W4PHPRW*[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]321[/TD]
[TD]73222WVTQYM[/TD]
[TD][/TD]
[TD]*73222WVTQYM*[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]321[/TD]
[TD]7X3949TK3LZ[/TD]
[TD][/TD]
[TD]*7X3949TK3LZ*[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]UPS[/TD]
[TD]A7A8459GVWB[/TD]
[TD]****[/TD]
[TD]*A7A8459GVWB*[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD="align: center"]#VALUE![/TD]
[TD="align: center"]#VALUE![/TD]
[/TR]
</tbody>[/TABLE]
I'm not sure if there is any easier way to show you the data, but the TORDET 3 is the start of ROW 3, the other numbers on the far left are not the row numbers, but the numbers for the information within the cells. I'm using Excel '13 as well. If someone could help me with this it would be greatly appreciated!