Convert Weekly Off into Absent Excel VBA

Would request you to help me providing excel VBA code which will replace weekly offs and holidays into absent in Sheet 1 if employee's attendance status is absent before and after weekly offs or holidays

In Sheet 1 we have attendance record Example...

Employee ID, Name, 1-Jan 2-Jan 3-Jan 4-Jan 5-Jan 6-Jan 7-Jan 8-Jan
M012345 ABC Present, Present, Absent, Weekly Off, Absent, Holiday, Absent, Present

In Sheet 2 following columns contains list of text used for Present, Absent or Weekly Off and Holidays.

Column A = List of text used for Present
Column B = List of text used for Absent
Column C = List of text used for Weekly Off and Holidays

In above example in Sheet 1, I am looking for a excel VBA CODE which will replace the Weekly Off and Holiday into the word "Absent" in Sheet 1 because employee's attendance status is absent before and after weekly off or holiday and this logic should get checked for all the rows with data

Thanks in advance

As the code will depend on data layout, please read the yellow banner at the top of the page.
Or skip to extended version of it below:

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If there are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, empty cells between data, mixed text/numbers, merged cells, some important cells filled with content by macro/manually/by formula, etc. - please show them all, or at least indicate in text). The use of unrepresentative data and formats is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following (paperclip icon does not work!): Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.