If anyone could please tweak the code so that it continues to copy the cell content from the first worksheet, I'll be finished with this. I have changed the workbook so that all the sheets have the same format as the first one titled "lead input".

It doesn't copy anything beyond the F column onto the other sheets, I need it to copy all the way through the V column. Then, I will add other columns to some of the sheets past the V column, but those won't need any cell content to transfer over.

I would really appreciate it, thank you to everyone who's helped out.