Sharepoint, Excelfiles, filter, teams

Hey, 

Hey,

I have been looking for a solution to make it easier for me and my colleagues and I hope someone can give me some tips or advice what I can do.

We have a team site in sharepoint With different folders:

Warehouse: In This folder, each employee has a excel Workbook with data and material that we used that day with the customer.

Dispatch:

• This includes all employees a excel Worksheet with the customer's data and what we have done
• On yet another excel Worksheet, we note the Repairs/cancels Of that day

So We are always every day again 3 to 4 times the same to fill what leads to problems.

Can I not somehow make sure that all employees on 1 excelwerkblad Note All: Customer data, install/repairMaterial...... etc. and that excel Automatically filters the correct data to the correct werblad Copy so that it does not have to be filled in again

Day report: All employees record everything in this

Repair/Cancel:

Material

I hope you have some tips or Ideas Have, let's come 😊