I need to create a macro that does all of the following in order;

I open a new workbook and start my macro which
1. goes to a specific folder and opens all of the files in there (excell
spreadsheets)
2. for each file I need the macro to highlight all of column g and do a
"text to column" with the output being input into the workbook I opened at
the start with the output from each individual file being inserted under the
output from the last one.

Is this possible?

Thanks