Hi I have the same question except I need mine to cycle through 5 sheets all with the same headers.

Any help would be greatly appreciated.

Im thinking a For Each would be appropriate in replacing the With statement you have but Im new to VBA and not too sure.

Thanks in advance