Group certain sheets in one sheet

[Afarag]

Dears,

i have more than 30 sheets that contain the same criteria of data in whole workbook, i ask to group all sheets in One and set vba



3/24/2014
Morning Shift
9:00 AM--6:00 PM

9:00 3/26/2014
Annual

9:00 3/27/2014
DO 3/28/2014
Morning Shift
9:00 AM--6:00 PM
9:00 3/29/2014
Morning Shift
7:00 AM--4:00 PM
9:00



the above row a sample for the sheet i ask to export

if the cell contain time as 9:00 AM--6:00 PM or Annual or DO will be exported in this cells

have a look to the attached sheet

Gratefully,

 

[SirJB7]

Hi, Afarag!
Check if this isn't the same that you're asking for:
http://chandoo.org/forum/threads/me...ets-in-a-master-sheet.11074/page-3#post-91617
Regards!