Macro to rearrange data in excel- merge 3 cells and move sheets

Registration date
Wednesday September 16, 2015
Last seen
September 16, 2015
I am just starting to use macros and am lost on figuring this out.
Inventory comes in a 9x9 box with position 1,1 (rows, columns) in the bottom left
I have an inventory spreadsheet I get in that has 4 columns of pertinent info. Column D,G and M all have info I need to combine and place in a cell location based upon column 14. Preferably the data would be formatted to have each of the 3 original cell data on a new line within the new cell.

Sample Input

Sample Output