Merge Worksheets and Sort Data by Category

[kingsdime29x]

Hello:

I am trying to sort the worksheets in this Excel workbook so that I can go through them and organize by category. I'm trying to find a solution to make it go through and organize quickly instead of going through each sheet one by one.

For example, I would like all of the Defense tables from all the worksheets to be put into one worksheet named Defense and this process to be done for the other tables I have in the workbook.

I haven't been able to find a solution for this. Any feedback or assistance would be greatly appreciated. Thank you in advance.

[jindon]

VBA

Please Login or Register  to view this content.

[kingsdime29x]

This is perfect! Thank you so much!!