Hi, i am working on a report sheet to make my life easier.

I have a sheet that i fill out daily, each day has numerous boxes with different information, i was wondering if there is a way to 1 click 'copy' this information to another sheet in a single row.

I have attached the sheet and a proposed result, only way so far is to = each box manually.

any help or directions will be much appreciated

thankyou

frmula.xlsx