Arnab,

sorry, but your data layout is less than optimal, to put it mildly.

Your question lacks some more information. Based on the data you posted, what data should be entered in which cells on the site sheet? Based on which processing logic?

Get rid of merged cells. They only complicate matters.
What is the significance or reason behind using Forms control buttons in lieu of cell data labels? Do you want to make things particularly difficult?

Based on the data in the "planning" sheet, which (merged) cell(s) in the "sites" sheet should receive what value?