Hello,

What I have is a workbook with a data tab, containing many rows sorted by different item names. Following the data tab is a tab for each item from the data tab. What I am trying to do is write code that will look at the item name in Column A (within the data tab) and paste those rows into the correct individual sheet. For example, if I have a tab called "Item1", I want to go into the data tab, search Column A for "Item1". Let's say that rows 2-10 pertain to "Item1". I then want to copy those rows and paste them into row 2 of the tab called "Item1". I would then repeat the process for the rest of the items. Any help would be greatly appreciated.

Thanks,
mulcahcf