I have 2 excel worksheets, both are in different formats. Both will
contain the same data but spread across different parts of the
worksheets.

if I have filled in the data for 1 worksheet, how can i automate this
data to be filled into the other worksheet?