Copy day Booking Data, Find Worker to assign to and paste on next available row

Hello All,

First post here, so excited to learn and develop with you guys.

I'm looking to have 7 days across the columns (each day having 4 columns of info).
Set x or however to the originating column id ie 4 if column D.
Find the member of staff - fine with this part
navigate using offset utilising x so data stays in same column
*paste data
return to original selection and clear contents

*Would be nice to check if blank before this stage if poss also.

Thanks for any help you can give me!

Craig