autofit cell height for merged cells

Dear Team,

I have a problem with auto fit height with merged cell.

I am having sheets Data, Sheet3. Sheet3.a. In data sheet i merged C5&D5 cells and entering address and the same was copied to Sheet3 & Sheet3.a with range of B8:F9 which is merged.

When i am entering the address in Data C5&D5 the entire row should auto fit and also Sheet3 & Sheet3.a also to be auto fit automatically.

The sample file is attached here.

Can any one help me for this
Attached Files Attached Files