Dear All
I am trying to copy data from all sheets in one workbook but NOT copy from the HOME sheet and the Prog_Dep sheet, here is my code it copies but also copies these two sheets that I do not want it too.
Sub CombineData()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Name <>...