Copy-Merge w/ Exclusion in Command Line

I have a network drive that has hundreds of folders in it, each with a few files. The one of interest is an Excel file named XX_Form_54. I would like to create a folder on the desktop and add all these Excel files to that folder using the Command Prompt on Windows.

I've already tried using

echo Starting Now xcopy "source" "destination" echo Back Home pause

All this does is copy the files in the source directory, nothing from each folder. Any suggestions? My ultimate goal is to then merge the Excel files into one large Excel document.

Thanks,

Recent Questions...