Basic VBA or Match and Index formula needed for UNIQUE COLUMN WITH VALUES

Hello everyone, I hope my image will explain the issue I am facing in my forecast table. I did try through MS Forum and I got half way through the solution through one of the expert but I thought to post it here so maybe someone may have different approach to the issue
Your prompt answer will be greatly apprecaited
N
Screenshot 2023-12-05 at 12.54.25 AM.jpg

sure , thank you for your guidance and here is the file which I hope the picture will be like and additional explanation

Anyone who can help please?
Thank you very much in advance

Hello VBA Pros
I think now I have better test file to give you exactly the issue I am facing and I am hoping you can help with the VBA code as you will see in the file there 2 sheets, 2024 CASH PLAN and 2024 CASH MOVMENT . I put all the data i need in 2024 CASH PLAN and then I try to summarise it every month in 2024 CASH MOVMENT. I managed to sort out the formulas that extract the data I need based on entered data forecasts in first sheet, however the only issue I find now is the following
1- as you will see in column C, and I enter the dates manually every month in order to decide how to sort everyday my payment plan which means simply I need this to be manual as it is every day changing based on the cash position. the beneficiaries and their amount based on 2 criteria ( which are the month and what type of action is given for that payment whether to pay or hold) are coming up smoothly but when I sort out the dates whenever I decide to change the date so I can get ordered list based on my new decided dates , i get the message (You can't change part of an array) I understand that there is no way around as I have been spending hours trying to find out if it can be done using formulas and it feels to me that this can only be solved by VBA. Please correct me if I am wrong and please let me know how to sort this issue out as it will give me huge relief of doing things manually

Your attention to this would be greatly appreciated
N Bek

I would add that something like putting a botton in the cash movment sheet linked to macro when I push it is sort out the dates with all values in beneficiaries and amount