move rows to new sheet based on text and date in multiple sheets

[myjebay1]

hi all

i have multiple sheets with ids and dates in a row and then the data following



in some sheets the date may be in column a and the id in column b and vice versa in a different sheet.

i would like help on making a macros that uses ids and dates to put all the data from all the sheets into one sheet with corresponding ids and dates being one single row.

i have attached the macros would be able to do.
ideally, it could do this for many ids and dates all on different rows in different sheets all putting them into one sheet.

ex1.xlsxex2.xlsxfinal ex.xlsx

thanks!!