Macro help: Separating data into tabs and creating a table of content of those tabs

So I have the attached workbook (http://www.filedropper.com/macrohelp) and would like to have a macro that splits my data into multiple worksheets based on column A of each tab.

For example: Sheet1 contains only one category in Column A - called "Tab_1" -, so only one Tab labeled "Tab_1" will be generated containing the respective data labeled with "Tab_1". Sheet2 on the other hand contains three categories in Column A: "Tab_2" "Tab_3" and "Tab_4"; so in this case 3 tabs will be generated with each containing the respective data labeled under each category.

Can anyone help with a macro that goes through each sheet in a workbook and generates tabs based on Column A in each sheet?

Lastly, I would like to have a table of contents of all tabs that were generated and have those listed in a sheet and with hyperlinks to each respective tab. I put an example in my file. If the hyperlink part is too difficult, just a sheet with a listing of all tabs should suffice and then Ill manually hyperlink them.

Thanks guys

Ps. I did my research and found the code lusted here (http://www.extendoffice.com/document...-column.html); however, that only works for one sheet at a time and does not help me in my task of creating an index.

There are 16 tabs each of which contains a different number of categories for Column A. So for example the first tab contains 3 different categories in column A; so 3 new tabs will be generated from this first tab (one for each category). Then the second tab contains 8 different categories in column A; so 8 new tabs will be generated from this second tab (one for each tab) and so forth.

Thanks for looking into this!

The 16 tabs are labeled from 1 to 16. So literally "1" "2" "3" ... "16"

thanks! works great

Hi, I was wondering if anyone can help generate the same code, but disregarding the first part "Can anyone help with a macro that goes through each sheet in a workbook and generates tabs based on Column A in each sheet?". I only need have a macro that hyperlinks each item in a column to its respective tab.