Some VLOOKUP, HLOOKUP, MATCH and INDEX combination which can pull the data from tables in different format into one summary sheet

I want some VLOOKUP, HLOOKUP, MATCH and INDEX combination which can pull the data from tables in different format into one summary sheet. One of the tables is in this format:

Name Date Scores

Sam 1 jan 23

Aron 1 jan 27

Alicia 1 jan 21

Sam 2 jan 24

Aron 2 jan 26

Alicia 2 jan 29

Sam 3 jan 20

Aron 3 jan 20

Alicia 3 jan 21

Other table is in this format:

name 1 mar 2 mar 3 mar 4 mar 5 mar

Sam P A P P P

Aron P P P A P

Alicia P A P P P

I want to create a summary sheet where I can pull the data from both the sheets accordingly like this:

Name Aron

Date Attendance Marks

1 jan P 27

2 jan P 26

3 jan P 20

I figured out the attendance sheet. I am using VLOOKUP and MATCH combination. However, I am experiencing issues pulling out the data from the first table. I can't figure out what formula to use.