Collating Information from Multiple Spreadsheets

Have a spreadsheet which contains numerous strand of information, mainly concerned with data pertaining to customer visits.

Would like extract the employee's name who will be taking the visit and report this the the customer.

Problem incurred. Some customers have multiple visits daily, data is being collated from daily spreadsheets onto a weekly format

My skill level within excel is somewhere between "more than my colleagues - less than you", mostly self taught and do not always understand the terminology used by experts.

Believe there is is a vba code somewhere which could help, hoping someone will save me

Hi Forrest and welcome to the forum,

Power Query might have the tool you are looking for. If all those files are in the same folder, you can import only the parts of each file you want. See:
https://www.myonlinetraininghub.com/...%20items...%20
for a start. BTW - if this answer doesn't give you a lead then keep asking. Also, attaching a workbook will get you much more help here.