concatenate based on User input

Hi,

Wish you all a happy Christmas.

Need a help with Concatenate which is bit complex

I have data from Column A to Col Z with more than 1000 rows of data ( in Column AA, I want to concatenate few columns like A2, C2, Y2, Q2 etc.
If the formula is standard one i would simple put = A2&C2&Y2&Q2 for all rows. The challenge is these concatenates has to be dynamic based on Headers that I put in another sheet.
Based on the headers keyed in Sheet 2, the concatenate formula in Sheet 1 Col AA should be updated on the same order. like =B2&E2&A2&D2&N2
ex
User Input in ( Sheet 2 Col A)
Header2
Header5
Header1
Header4
Headers 15
etc

Sample file attached & Similar post is here

https://www.mrexcel.com/board/thread.../#post-5609122

so what's wrong with the ans in the other post? i would bet that you can do this w functions, however I do not use them, nor do I care about them. this is about the only thing I could think of:

Please Login or Register  to view this content.

in cell b2 of sheet ''sheet 2'':

Please Login or Register  to view this content.

not sure if that will work for you or not.

Please Login or Register  to view this content.

Kind regards
Leo