Hi - I need help with my excel sheet; below are the details:

Two tabs ("Sheet1", "Sheet2")

I need to run code to search Column A in "Sheet1" and eventually replace columns B, D and E of the same spreadsheet with information from "Sheet2" depending on the search results.

The code would tell the spreadsheet:
If the first 4 characters of any cell within column A on "Sheet1" match the first 4 characters in any cell in Columns A, B, or C in "Sheet2", Then Columns B, D and E on "Sheet1" would be replaced by Columns D, E and F on "Sheet2" in that specific row.

I hope this makes sense. Thanks for any help in advance!