Getting data from one workbook to another

Hello!

I am working at a firm and we are currently getting help from some external consultants. In this connection, of course, we have to pay for the help. However, there is a lot of consultants and the payment for each consultant depends on their level of experience. Once a month we get an Excel-file with the registered working hours for each consultant. In that connection we have made our own Excel-file where we are keeping track of the working hours so we can check the invoices they send us. At this point we are typing in the hours manually, however, we would like to automate this process. My question to you is:

How do we get the data from the file the consulting firm are sending us to our own file?

The names of the individual consultants appears in both files. I was thinking that maybe there would be a possibility that we could make a search for matching names in the two files and from this register their workload

How do I do this in VBA?

Thank you for helping on advance

I would love to post the files here. However, legaly I can't due to generel data protection regulations and because of duty of confidentiality in the two companies...

Is there any kind of generel commands that might be useful in this case?

Thanks in advance

Hi again

I am sorry about the late reply, but I've been on vacation for a little month or so...

I've made 3 files with random generated names and made up company names to illustrate how it works. The program members file is the one that we have made ourselves where we are tracking the working hours for the individual consultant. The hour registration files are the files that we get from the consulting company each week... I've made a file for week 1 and 4. I've already put in the hours for week 1 to show how we wish to organize it. I have made a dummy-file for week 4 in order to have a test week and to see if any givin code is working or not. One of the difficulties is that the order of the employees is random from week to week, moreover, the number of activities that the individual consultant have varies from week to week.If an employee only have been working with one activity the amount of hours they've worked will appear in the same row as their name in either column G or H depending on if it is a cunsultant from the consulting firm itself or if it is from a third party. If the employees have worked with two or more activities during the week the amount of working hours will appear next to the cell with the activity. The total amount of working hours for the individual consultant will appear in the same line as RESULT in column E. When RESULT appears in any other column than E it the accumulated hours for the teams. We wish to have the total amount of working hours automatically registrered in the program members file.
If the working hours in one of the weeks are left blank in the program members file, it means that they have not registrered any hours for that week, and their name will in that case not appear in the hour registration files.

Do you guys have any suggestions to how this can be done?

Thank you for helping on advance

The files should be attached now