Can anyone give direction or guidance ?

I have a workbook with 2 sheets.
Sheet 1 is a overview (map) of the different storehous locations in a
factory. Each location have a unic number. It looks like this:

A B C D E
1 LOC A.1 A.2 A.3 A.4
2 MAT1 442 433 458 433
3 MAT2 485 0 442 0
4 DATE 5.2 4.1 12.2 20.1
5
6 LOC B.1 B.2 B.3 B4
7 MAT1 485 442 458 0
8 MAT2 0 433 0 0
9 DATE 6.1 18.1 15.2 16.1


LOC is short for Location number, MAT1 is short for Material number 1, MAT2
is Material number 2, DATE is the date when the last material arrived at the
location.

In sheet 2 I have listed up all the Materialnumbers in column A and when
goods arrive I put in the Location numbers where the goods is physically
placed in column B, C, D and so forth. It looks something like this:

A B C D E F
1 433 A.2 A.4 B.2
2 442 A.1 A.3 B.2
3 444
4 445


I have just put in the location numbers for two material numbers in sheet 2
in order to illustrate the situation. I have also limited the amount of
different material numbers on each location to two in sheet 1.

Now comes the challenging part ....

1.)
I want sheet 1 to automatically be updated with material numbers (MAT1 and
MAT2) from Column A in sheet 2 when I put in the location in sheet 2. In the
illustration above I have put in Location A.2, A.4 and B.2 in row 1 where
materialnumber 433 is loacated. Then I want sheet 1 to automatically be
updated with materialnumber 433 under Location A.2, A.4 and B.2 - as in the
illustration above. In B.2 we can see that materialnumber 433 is
automatically placed as MAT2 because MAT1 was occupied with materialnumber
442.

I assume that this is very difficult to manage without a VBA code ?

2.)
Futher I also would like the date for the last movement in the location
(change of cells in the rows with MAT1 or MAT2 in sheet 1) to be
automatically logged.
This for sure needs a code.

Unfortunately I am not able to figure out this with the use of the available
functions in Excel. I assume I will need a VBA code or at least a UDF in
order to solve this ?

Will anyone take the challenge ?