Copy multiple cells based on another cell's value

[vedranc]

Hello!

I need help with multiple linked values and their sorting, copying..

I have one workbook with values like this (informative only)
A | B | C | D | E | F | G
ID No. | Height | Weight | Age | Color | Rating | Price

ID number is the most important value, based on that value all other values are entered manually and that's ok. Id number grows as rows add (row 2= ID 252, row 3 = ID 253, etc.).

I need to copy those values to another workbook but in different order. ID numbers are already in the other workbook, I just need to copy other values connected to ID number in order like this:

A | B | C | D | E | F | G
ID No. | Rating | Price | Color | Weight | Height | Age

So basically I'm constantly adding, copying values to Workbook 2 manually..
Can it be done more time saving and how?

I was thinking of a macro button next to each ID Number which will copy values in corresponding columns into the other woorkbook in different order. Or, can that be automatic? With one button press?
I really don't know how to do that. I want to get rid of manually copying of every value to another workbook, so I need advice..

Also, since those workbooks have large amount of data, would it be better to store them in access. I'm pretty newbie to this so any advice, guideance will be helpful..

Thanks in advance!

Vedran C.