|Without some idea of how your data is laid out, it's a little tough to give you a specific answer.|
A common method for pulling data from one range to another "based on" something is VLOOKUP. If you read up on that function, you may find that it will work for you.
If not, or if you can't figure it out, you'll need to post some example data so that we know what we are working with. Please click on the following line and read the instructions found via that link before posting your example data.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.