sort an array by the dates in a different array

Hello, I have 5 data series in one sheet that contains the data (A) that would like to sort and their corresponding dates are in a different sheet (B). I would like to sort the data in A by a unique date series starting from the earliest date in B and ending with the most recent date in B. My aim is to get an array where the first column contains all the dates and 5 columns of data where the data not available for a specific date will be NA.

I have used the date column containing the earliest date but can't figure out how to sort then the data by its corresponding date column and then create the array.

Thanks for your help.

Hi Richard, see attached. First I have taken for instance the second column of sheet two that contains the larger date series and pasted in the 1st column of sheet3. Then, columns B,C and D don't need to be sorted because they all are in the same date range. Column A 1st data corresponds to July 2001, 23th and therefore is pasted in sheet3 from row 231 on. Column E data is pasted from row 144 onwards matching its corresponding first date (November 1999, 22th)

Thanks for your solution.