It depends on data..
Just understand the logic.......If you have all the categories name in one table on any sheet then VBA macro will find all the strings one by one copy all the below data till it find the other category name and paste it somewhere you want.