Macro to Export Data to New Sheet with tabs

Registration date
Tuesday October 22, 2013
Last seen
October 22, 2013

I am trying to create a way to export select data from a spreadsheet to a new one and send certain bits of data associated with a number to an individual tab. Basically I would have Column A and B where Col A has groups of numbers from 1-10 and Col B has steps filled with text assocaited with each number. I want the associated steps for group 1 to be sent a the first tab of the new workbook and so forth for each other number

Any help would be appreciated.

Thank You