Hi,
I have to write a macro for 9 different(huge) sheets with similar data. Got to copy 3 particular columns(SPIDs, Batch# & Date) from each sheet and paste onto another new sheet with data from each sheet being append one below the other. Just so you know, the 1st two sheets have SPIDs, Batch# & Date columns while sheet3 has SPIDs, Batch# & Process1Date. Please help.

Thanks!
kris