VBA - Copy and Paste data based on two criteria to specific start row and column

Good evening Gurus...i need some MACRO (in every sense of the word) assistance

I have a file (see attached sample) with two tabs

Tab1 is the input tab where data for each participant is manually entered into the GAMEx columns based on the results of the questions. the questions change dynamically dependent on which participant is selected from dropdown.

Tab2: Output and archive tab. contains a set of static questions used to change the questions in the Input tab. Also contains static columns where i would like to keep an 'archive' of scores for each participant dependent on which game was played.

(Hope it all makes sense so far)

So the help required

I would like to create a macro (button) that copies the game data for each participant from the Input Tab (based on the name and Gamex) and 'stores' it in the correct set of rows and columns in the Output tab e.g Selects Game 2 results for Mark and stores them in Cells H9:J13 etcTest_copy.xlsx

Thanks Mumps1 for your reply and code.

The code was able to copy the right data however when the game number is changed it does not paste the data in the right set of columns. ( I think that is my fault because i did not explain properly and there were some errors in the original file i attached)

i have attached an updated file and hopefully given a better explanation of the process i follow when using the file below.

Tab1: Input Tab
Step 1: Enter game # in B1 (this changes the major heading to Game #)
Step 2: Select Player (this changes the questions dynamically so they are specific to each player)
Step 3: Enter results in range E5 to G9


Tab2: Archive tab.
- Contains a set of static questions that form a question bank for the players questions in the Input tab.
- Also contains static columns where i would like to stores scores for each participant dependent on which game was played.

(Hope it all makes sense so far)

So the help required please
I would like to create a macro (button) that copies the game data for each participant from the Input Tab (based on the name and Game #) and 'stores' it in the correct set of rows and columns in the Output tab
e.g Game 2 scores (values only) for Mark are stored in Cells H9 to J13 of Archive tab when the button is pressed.
Game 3 scores (values only) for John are stored in Cells K4 to M8 etc..

Thanks in advance for your help and ideas Mumps1 and gurus

I forgot to mention also that the number of players in my real file is about 150...but i reckon if i can get an idea of how to perform the dynamic cut and paste for at least i will be able to extrapolate for the rest

Thanks again

Thanks Mumps1! you are the GURU It worked perfectly!