Excel VBA Copy one cell from some sheets and save on the another sheet

[Ierm]

I have 5 sheets : graph, sheet1, sheet2, sheet3 and list.
I have to copy the cell B3 from sheet1 and paste on graph in the cell C2, cell B3 from sheet2 to cell C3 etc. But I can't touch the sheet list.
graph1.PNG
sheet1.PNG
sheet2.PNG
I have to paste in the column C the values which are located on the sheet1, sheet2 and sheet3. But I have an error "type mismatch" in the row

Please Login or Register  to view this content.

This is my code

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.