I will give you a blank Master File with a Macro that will open up each existing file, copy the data to the next available row in the Master File, close the second file and repeat the process until every file has been merged. If any of the files have columns in different order the Macro will allow for that as well.
I can work under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the fee into the site.
I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting.
Would normally provide samples to let you judge my Excel skill for yourself, but you made this a "restricted" project. I can't send you an attachment unless you send me a Private Message first.
Hope you find this of interest and look forward to hearing from you.
Bob Allen-Turl