I have never written a macro in excel before. I am trying to organize my PTAs spirit wear orders for ease of placing the order. I have entered all orders into a master worksheet titled "spirit wear". I have separate tabs created for each size we are selling (22 different options). I would like the macro to search the master worksheet and copy the rows that correspond to the correct size.

For example, I would like all of the orders for L GC (large grey child) to be copied to a tab title L GC.

If anyone can help me, it would be greatly appreciated!
spreadsheet.jpg