Look up data in multiple sheets based on date

Hello

I need the help of you excel experts in this forum. I'm looking to look up data from multiple sheets based on date.

What I would like to do is to get the number from B3 for the name in A3 from the closest previous date. To explain furhter this is a club and the sheets are used for sales and the credit status (staða in B3) of each member for each meeting (fundur=meeting).

So the formula in column B, in sheets # fundur + Ægiskvöld + Árshátíð, needs to find the closest date in A2 before the date in A2 across the sheets named # fundur and return the credit status for the person named in column A.

In the sheet uppgjörsskjal I would like the cell C10 to look up data for A10 across the sheets based on the date in C6.

I hope I have managed to explain this enough.

Is there no one who can help me with this. Either with a formula or a macro. Please.