Hi Usman,

Normally you would do this by referencing the subsequent sheet cell to
the one where you have entered the data, so if in sheet1 cell A1 you
input a value, then in sheet2 A1 you would enter
=sheet1!A1

HTH

Ed

Hold down the Ctrl key and select the sheets of interest.......then enter
data in cell you want .......it will go in same cell on all selected
sheets..........

Vaya con Dios,
Chuck, CABGx3