hello. im currently working on a company spread sheet and am trying to automate the process a bit.
a b c d e f
1 san antonio 1111111 joe blow 123 main steet san antonio tx
2 austin 1111112 joe blow 123 main steet san antonio tx
3 corpus 1111134 joe blow 123 main steet san antonio tx
4 san antonio 1111156 joe blow 123 main steet san antonio tx

i would like to look at row "A" and identify a specific city, and if city is found, i want the whole row to be pulled over to another row altogether. i cant seem to figure it out. i would be very appreciative of any help i can receive. the best i can come up with is:

=IF(Sheet1!$A$2:$A$1104="valley",$A$2:$Q$1104=Sheet1!A3:Q953)

im refernecing another part of the worksheet so i can pull infofrom there straight to my workable cells. anyone have any ideas?