search prefix files names and moves to specific folder

[abdo meghari]

hello
every month I attach files (PDF,XLSX) in this directory C:\Users\PC Leopard\Downloads . the attached PDF extensions files contains names MN-2022-00010 , MN-2022-00011 ......
& the attached XLSX extensions files contains names Bridgestone Sales Report 04 APR. 2022,Bridgestone Sales Report 05 Mar. 2022, .so what I want create two folders for files PDF & XLSX files thier names are PURCHASE_PDF & SALES & RETURNS_XLSX and create folders months into them . for instance create folder REPOR_APRIL based on current month and move the files contain "MN" in the first part (MN-2022-00010 , MN-2022-00011 ......) from C:\Users\PC Leopard\Downloads to C:\Users\PC Leopard\Downloads\PURCHASE_PDF\REPORT_APRIL . as to folder SALES & RETURNS_XLSX create folder REPORT_APRIL based on current month and move the files contain MONTH
(04 APR) ( Bridgestone Sales Report 04 APR) from C:\Users\PC Leopard\Downloads to C:\Users\PC Leopard\Downloads\SALES & RETURNS_XLSX\REPORT_APRIL
I hope from the experts provide me macro for this project .
thanks

 

[abdo meghari]

 

[abdo meghari]