Lookup/Index + Re-order

Ok this is going to seem a little pointless, but it's part of a larger document which I can't share - mainly because i'm trying to rebuild it and it doesn't fully exist at the moment.
Example.xlsx

In the attached example you'll see two identical tables, one with data and one without - where I only reference one table assume the corresponding location on the other will have the same rules applied.
What I want is for the data from the second table to appear in the first but in order by the first column (AE:AF/A:B). I know there's the simple sort and filter functions, but in the final document the client will not have the ability to use them.
The data in table 2 is extracted from a 3rd party source, and the majority of the time it comes through out of order - so in the final document table 2 will be in the background and table 1 will be the table that the client sees.

I've tried to fill out the table as if it were a real one - however there are very few occasions where all 24 rows are used; it's usually between 4 and 10.
There may also be the odd occurrence where a value in column AE:AF is missed (i.e. you could have 1-4, missing 5, and have 6-8) In these circumstances I would require the missing value(s) to remain missing and not leave a space in the table.

Columns A:B, C, AA:AC are all number values
Columns J:Y will be either Y or N
For Columns D,E,F only one of the 3 cells on the same row will have a Y at any one time - the same applies to G,H,I (there will be no Ns)

Any questions let me know, as this is a work project i'll probably only respond during work hours.
Thanks in advance.

Nearly, but not quite.

Either method leaves a row of #N/A if there is a missing/non-existant value in the first column. As I stated above this is rare but it does happen, and I need to make it so that the missing value is still missing but not leave values in the table. For example if we had 1,2,3,4,5 but value 3 did not exist, I would want the table to list them as;
1
2
4
5

Also if I use the Macro method, iI get a table full of 0s where there was a blank box, and I can't have 0s in the Y/N boxes or the document will not validate.
I'm trying to reduce the amount of work that's required by the client to complete the document.

I've ended up with this;
{=IF(IFERROR(INDEX($A$3:$Z$26,SMALL(IF($A$3:$A$26<>"",ROW($A$3:$A$26)-ROW($A$3)+1),ROWS(AE$3:AE3)),COLUMNS($AE3:AE3)),"")=0,"",IFERROR(INDEX($A$3:$Z$26,SMALL(IF($A$3:$A$26<>"",ROW($A$3:$A$26)-ROW($A$3)+1),ROWS(AE$3:AE3)),COLUMNS($AE3:AE3)),""))}
it removes any blank rows and prevents and blank cells in the visible cells from showing as errors.