I have been using the forums as a guest for reference tools, have been a great help, but now I'm struggling to find a solution so I thought I'd ask.

I have been given a list that typically I go through, cut the information out and paste it into an identical list based on what is listed in the first column. Example, the rows all start with blue, green, red, or yellow in their first column. I'd go to a worksheet titled Red and cut all the rows that start with "red" and paste them into worksheet Red (basically, sorting out all the data and putting it into different sheets). Ideally, I'd just paste all the info (unsorted other than just by alphabetical based on column A) into a worksheet (lets title it DATA). Then the formula would take the info listed in DATA, and put it into Red, if the column A has the word "Red" in it. I can get this done with a basic vlookup, but problem is I want the entire row (A:N) in DATA to match what is put into A:N in Red. Plus, depending on whether I use False or True in the VLOOKUP, I only get the very first row or the very last row. Also, each entry contains 2 rows worth of data (So entry #1 really is A1:N2, entry #2 is A3:N4, etc). Then I'd repeat the process for Worksheet Yellow, changing the search modifier to be the word yellow instead of red, and so on and so forth.

Each "color" can have anywhere from 1 entry to dozens of entries.

Hope I've made this clear enough...If not, let me know, and thanks for reading through my question!