Copying cell to another sheet offsetting from a find reference point - see sample

[vkingxl]

Hi all, the title sounds complicated but it's pretty basic concept, I just don't know how to do this multiple times efficiently. I've learnt a lot about vba, but still in my infancy and more of a hacker to get things working.

Goal: Our EHTDB has many "holes" to be filled in, as users come across them, rather than having them go to the EHTDB tab and scroll to find the right cell, I made simple macro to search and fill in the cells automatically from the Template.
I want to copy user data from template sheet ("+WN") to the EHTDB sheet based off the reference ID.
I have built individual macros to copy each individual cell, but would like to simplify it so one click on a macro will check each of my 5 cells (ignore if blank), and copy the user data to the correct row in the EHTDB with the correct column offset.

See attached working example with single macros.

Sample of working single macro code:

Please Login or Register  to view this content.

Appreciate any help you experts can provide!

[WideBoyDixon]

I replaced all those macros with a single one:

Please Login or Register  to view this content.

WBD

[vkingxl]

I'm not sure what happened to my last reply, but I'll try again.
WBD - thanks so much for your help! Big Grin on my Face for how awesome this made me feel seeing it work PERFECTLY as envisioned. Thanks for adding in the comments to help me understand the code a bit too. Best wishes!