|Chevella - please post this as a new post.|
When posting you will need to be more specific.
Explain the criteria for moving your data in column C
I presume you have one workbook and a several worksheets in it.
What are the Worksheet names
What is the relationship between the data in Column C and these worksheets.
Do you intend to have just one cell (a cell in column C) moved to a different worksheet - meaning that each worksheet only has one cell with data.
You also need to say what happens if you run a macro a second time - is data added to existing data, is the original data in the destination worksheets replaced.
To get a usable response you need to provide lots of detail.