How to have a data constant that merges upon copying data into the cell from another WB?

Hello Everyone,

It's been awhile since i've visited but i've returned with a help request. I have 2 workbooks i have working with. Workbook 1 has constant headers and also has column A which has a constant "HomeDepot:" in the cells throughout that column. What i want to do is copy data from workbook2 which has different data in column A "John Smith" for example, as well as other data in other columns. I want to be able to copy all the data in workbook2 and paste in workbook1 but with retaining the constant data in workbook1 column A and merge them. For example: "HomeDepot: John Smith". I also want to be able to automatically have 1 space created between the : and the first letter of the data that is copied into the cell. Please see the attached screen shot for further clarity! Thanks!

John