Loop through worksheets to copy data to new workbook

Another option

Hi AB33 thanks for the reply! but I tried your macro it did not work...gave me a blank new "master sheet"
I am not sure why because it worked in your sample file.
So I attached my original file for your reference Raw Format.xlsm
This is the exact file format I am working with except I removed the confidential data.
What I want is as described in the post. Thanks!