To maintain the bills

Hello guys,

I have a senerio and I need to automate this to reduce my work.
senerio: We are a team of 20 working in a small company. Every day we order lunch from 3 different Restaurant.
Currently, every guy send me his order looking at the menu. I have to sort it based on the restaurant and send it to respective restaurant. I also have to keep in track of the bill.
Instead of receiving the mail from each, can we automate this in excel and get final orders separetely for each restaurant.
Please help.

Thank you

Hello Kevin,

Thank you for your reply.
Your idea is good. But looks complicated for me as I have little knowledge of VBA.
I did not understand the term EmpFile.
Sorry I forgot to mention, Each day the Menu changes in two of the Restaurants.
My idea:
Create three different files(restaurant 1,2,3) in a server(LAN) with restaurant names. This file has 3 columns(Name, Item Name, Cost).
Since I get Menu form different Restaurants(in word format), I forward the same to all. I receive the Menu on Monday for the whole week.
Every employee has to enter their order in any of these three files(restaurant 1,2,3) with the item name and cost.(Name of the employees is previously entered)
Now we have 3 files ready to send to respective Restaurant.
But I should create a master file with column Name, cost on Mon, tue,...fri. This master file should extract the values form those 3 files
every day. At the end of the week, I have to settle the bills.

Work to be done: Auto create 3 excel files every day with the name of the restaurant.
Extract the values from these 3 files to put it in master file.(I do not know how to extract values from closed excel file. But I can learn and try)
The files which we auto create everyday can be deleted after one week or a month.
Master file should have column NAME, ORDER PRICE ON MONDAY, TUESDAY,........FRIDAY, TOTAL.


Please let me know your opinion and correct me If I am wrong. I might be thinking in a different way, as I have little idea about VBA.

Thanking you