Does anyone have any suggestions for the following:

Beginning with the third sheet in the workbook I would like:

If any Cell in Column A = "Variance" (for all sheets in workbook) Then:

Copy the Cell in Colum "C" (in the same row as the text "Variance" in Column A) to :
Column A beginning with Row 10 in the Sheet named Variance in the workbook.

Any help would be greatly appreciated!