Hi
I have to a workbook with 31 sheets
I wish to paste the unprotected data from each sheet to another workbook in the same particular named sheet and same cell as the previous work book

I cannot use the copy sheet in excel as the formats of the sheets are different giving me different out put through formulae

I wish to delete the previous sheet once data is trasfered
please assist me with a macro to do so.