I receive about 50 spreadsheets a week for a survey. I need to consolidate
the information into one spreadsheet. How can I crete a macro/formula/vba
script which will automate this process so that I don't have to open the 50
spreadsheets? Thank you.