Hi,

You want to copy data from "RENAME" sheet to Sheet "ADF 1282" (if cell C10 is "ADF 1282") and so on...
Please tell me the range needs to be coppied and the target cell in "ADF 1282" sheet where it is needed to be paste.

Regards
taps