Please could anyone suggest the code to do the following.

I have a control workbook called "STORED" with a worksheet called "INVENTORY".

I also have a folder "C:\COMPLETE" in which are stored upto 10 workbooks witch have no fixed naming convention. On each of these worksheets (in column A) there is a list of data with no set length (also there are some "merged rows").

I need some code to copy all the data from column A of any worksheet(s) into Column A of the "INVENTORY" worksheet in Workbook "STORED".

I want the data to be pasted to form one long data list from all the worksheets in the "C:\COMPLETE" folder.

Also i then want to programmatically sort Column A on worksheet "INVENTORY"

Please advise.