Copy and paste a group of columns multiple times based on value

[DY93309]

I'm a new VBA learner. I am going to make a summary sheet for this kind of form:
3.PNG

Eventually, this workbook will have more than 120 forms, I want to use VBA to loop all forms, then make a summary sheet in the same workbook for them. All forms have the same format as the image shows.

Here is an example I made:

The really complicated code I have now (I combined them from other's help):

What I am expecting for is:
222.png

My question is how can I copy paste people's names, the position, and numbers based on the Column A? Thank you in advance!

[JLGWhiz]

I won't try to develop a procedure for the output you want, but if it can help, I will offer a suggestion since you stated that you are new to this type of data management. The first thing that should be considered is the data base construction. You want your data entered into columns and rows so that it is consistent by type and title, i.e. Names in one column, age in another, emp # in another, etc. If the boss wants to see the data a certain way, you can do that with the output. But the input should be so that you can easily access the data and can know exactly where each type of data is located. I am sure there is a purpose is using multiple tables for your data, but it makes writing code for it complex. If the data was columnar, it could easily be sorted, manipulated, calculated and output to specific formats.

All that said, there might be someone who will attempt to write the code you want, so don't get discouraged.

[DY93309]

Hi JLGWhiz, thank you for your reply. You are right, I will keep learning the fundamental knowledge, I also hope someone could answer question since it is the final step of my task.