INDIRECT with conditions problem - spreadsheet copied weekly same rows/colums/names

i think this is what I need although I don't know... maybe I complicate things.
Tried your solution JBeaucaire ( I AM SO GRATEFUL can't remember how many times I tried to automate this.. I always copy week arrears to previous arrears on the new sheet.. which is so time consuming..) but it returns value error I formatted D1 to MM.DD as well as named tabs in same format so MM.DD


I FOUND IT!!!!!!!! the formula had O:D for first criteria instead of O:O
You really made my day and work way easier from this day on! I hope one day I'll be as good as you are! Thank you again!