Consolidating Grouped Worksheets into one 'Master' Workbook

Hi Everyone,

I found this VBA Script online, but I was hoping to receive some help in modifying it to better adjust my needs. I would like the VBA script to do the following:

Consolidate any grouped worksheets (Ctrl Right Shift) into one. Take the header (row 18) from first grouped sheet and have it be the header in the "Master" Sheet and have it start in A1 and the data below row 18 is consolidated underneath it (removed formatting, except make header bold).

I'd really appreciate someone's set of eyes on this, Thank you!

Please Login or Register  to view this content.

Unfortunately not everyone that will be using this workbook has the newest version of Excel. I wanted to make it an easy script that anyone could run.