Wriet into excel column with dynamic column name

Can anyone please provide some solution for writing a value in a particular column
(say amount value in Amount column) in a excel sheet. wherein the excel contains 5 sheets and Amount column name index is not constant in all the sheets. Also the Amount column has some pre defined formula for automatically calculating % value in next column.


This information will be useful