moving contents from 1 sheet to another in a different format

[yt400pmd]

thank you for looking at this post! i am very new to excel, i didnt even know some things were possible that i have read here. i am looking for guidance

i get data in a spread sheet and make it easy to understand for others.

this how i receive the data
https://drive.google.com/file/d/0B3KdH7m_fcjxS1dJLTVJaDlPaV8tUDFGXzhPNnd0LXV1eU9Z/view?usp=sharing

this is how i want the data to look
https://drive.google.com/file/d/0B3KdH7m_fcjxVGFTcVJiT0RNNzdWdGZTOWdfb2V6cmFnY0tV/view?usp=sharing

i have been doing this by linking cells from one sheet to another and linking, BUT sometimes the original is slightly different.

if there is already a thread on this please direct me to it. if this is something that you can teach me please do. i have signed up for an another excel class but i have no idea if it will teach me the magic you all create.

thank you

 

[yt400pmd]

windows 7
office 2013
i changed the phone #s for privacy

thank you