Associate Multiple Cells with One Cell

[geno32080]

Can a Macro be used to associate Multiple Cells with One Cell on the same sheet and then be copied and pasted to another sheet? The association would be B4 = C4, C5, C7, C8 and C9.
If I select cell B4, on sheet 5, that cell and the associated cells get copied from sheet 5 and pasted to sheet 3 starting with the B4 pasted to cell B15, and then C4 thru C9 pasted to cell D15 thru D19?
I don't know if that's even possible. I've tried Data validation, but that was a dead end. I'm up for any suggestions. Thank you.

 

[Joe4]

Made one small adjustment. "Work Order" changed to "CREATE WORK OPRDER" and BOOM! Like a champ. You are the Excel Macro Man!

Thank you.

You are welcome!

Yes, you would need to change any sheet names that are different to match the name of your sheets (as we could not tell exactly what they were from the screen prints).