Macro Help - copying A to B under changing specific criteria

Hi all

I am not the most savvy of excel users but it is essential for my job role and I am more than willing to learn.

My workbook contains over 1600 individuals, I have been asked to start including a new set of data for each individual. Due to the report system at my workplace, I will have to update each individual one by one which will take me a very long time indeed. I could do it manually but I aim to create a macro that will speed up things.
I have two worksheets, I'll name them Alpha and Beta.
Alpha contains a table in which I have copied data from our reports into. This data is for one individual only (there are no large scale reports for multiple individuals). Alpha matches the format of the report.
Beta contains all 1600 individuals with new data fields for the data I need in Alpha
What I want to do is create a macro that will automatically take the data I have copied into Alpha and put it exactly where I want it in Beta but it has to be in the same row as the specific individual.
Each individual has a unique identifier to link both worksheets together. I figured Vlookup would be the best function to use. How can I program a macro so if I was to put the unique identifier into Alpha, Excel would know where to find the unique identifier in Beta and copy the data from Alpha to Beta into the right location.
I have attached an example. I've color coordinated it for better understanding of where I need things to go.
I hope that all makes sense
Any help will be greatly appreciated.
Many thanks
Nick

Many thanks for your reply. The only relationship between Alpha and Beta is the unique ID number. There are 1600 individuals in the actual workbook I have and they all have a unique ID number. The dates themselves are purely for my own reference with the actual data and I probably shouldn't of included them in the example. In Beta the dates have no significance as the data I collect is from different time frames for each individual.
The colors are simply to show what data I need to copy and to where as an example.

What I am basically trying to understand is if I was to input a different ID number into Alpha, how can I get excel to recognize this and place the data in Alpha in the same row as the unique ID in Beta. So it simply becomes a case of copying the data from the report and pasting into Alpha, run a macro which then places the data from Alpha into Beta into the right cells at the touch of a button.

Hello
I was working on this example before Alan replied, so I waited for your clarification. Does the macro in the attached file do as required. The ranges here are fixed to your example but could be amended to suit. The ID is taken from cell A3 on the Alpha sheet. However, this all depends on your data layout being consistent throughout.

DBY

Hi DBY
Many thanks on working on this for me, I really appreciate it. It is exactly what I had in mind. I'm going to try and implement it into my actual workbook and see the results. I will let you know how I get on.
Thanks again
Nick