need vba help transfering cell from one worksheet to another

[justme1052]

I'm trying to figure out how to set up a kennel rating chart. trying to see if this is even possible to do. the 3 charts I'm sending are what I'm try to accomplish. the first chart is a downloaded chart I download nightly for greyhound racing. the second and third chart is ones created to try to keep up the kennel ranking daily.
The first chart shows the greyhound in each race. on the left #1-8 shows the post the greyhound is running in, middle is the greyhound name, on the right is the kennel number the greyhound is racing for.

The second chart is almost the same except the next morning I keep results records and the second chart shows the results from each race and to the right shows the kennel list and a #race chart. which I want to tell me how many races each kennel is racing. example #1 is the Patrick Collins Kennel, so I need to know the number of greyhound #1 (Patrick Collins) is racing tonight. Its possible the kennel has two greyhound in a race. so I need the # races chart to tell me how many #1 there is in the 15 races tonight. then the same for each kennel #.

The third chart is the main chart. if you look in chart 2 you see the results is 4251. I want the results to go into the correct cells in chart 3. even though the 4 won the first race, I have to look at chart 2 and check the results. # 4 is the post number but if you look you see the #4 is running for the # 8 Crowe Kennel. so in chart 3 the win goes to the #8 kennel , #2 place goes to # 5 on the kennel, # 5 show goes to the # 4 on the kennel list and the #1 4th place goes to the #14 on the kennel list.
long story short after the results are added I want my chart to show each day how each kennel did the night before as far as coming in W-P-S-4th and how many greyhounds each kennel had running. on the bottom line of chart 3 where it has
Races>> you see o o o o o. this is my double check insurance. the number of races will read 120 because there is 120 greyhound racing nightly. 8 greyhounds each race and 15 races, (15x8=120) so you know you will have 15 win,place,show, and 4th when the chart is finished. 120 15 15 15 15 is how the bottom line will look when finished.
is this even possible to do. if so please show me how to get started transferring the results and number of races to the proper kennel number in the proper win place show 4th.
please ask any question you may have. do I need to rearrange chat 2 and put the results in a separate cell for each number.
how do I write codes or scripts to get started. thanks in advance for any help and info.

[FDibbins]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[justme1052]

I change the tittle, will this one be OK?