Wanting to write a macro to concatenate and store info.
 

I am new to macro writing in Excel and I would like to do the following things.

1. Take data from one whole column of vaying lengths in one spreadsheet and
store it into another spreadsheet in a different column.

2. Take three columns of data with the same lengths in one spreadsheet and
concatenate them, with some text between them, into one column of cells in
another spreadsheet.

3. Delete rows in the new spreadsheet to eliminate the unneeded rows that
have the word "OPEN" in it and shift the remaining rows up.

4. Automatically take the concatenated cell and CAPS all of the letters in it.

I have about 700 individual spreadsheets that I need to parse out this
information into separate spreadsheets with only the info needed. This is so
one system can read the files from our vendors. The format that they are in
is needed for an even larger parts tracking system so our system is not as
important until it gets to me. DOH!
Any help anyone could give would be greatly appreciated.