dont know how to explain this one

here's one to trouble you all with.

7 x worksheets for daily payments and 1 for owner payments.

can i have a column in each daily reception payments with a drop down box with owner payments in it so that when owner payments is selected that data from that row will appear in the owner payment sheet?

if so how?

File attached
thanks for your time