I'm sorry for the odd title - I am having trouble putting into words what I want, and I think that's why I can't locate it via Google Search.

What I am wanting to do may not be doable with Excel ... I don't know.

Is anyone aware of a tutorial that would show me how to allow a user to "upload" a xls or xlsx file from a userform. Once they select their file from their HD, I want excel to "read" the file and sort it in a predefined way. The file being uploaded would be very specific, so the formatting would be predetermined, I just want Excel to read that file and spit the data into a table on the worksheet.

Basically, the user could accomplish the same task by copy/pasting from workbook 1 (raw data) into workbook 2 (where the userform exists) - but I need to account for least common denominator, and try to "dummy proof" the process as much as possible...if I entrust them to "copy paste" properly, the liklihood of them making mistakes is greater-than-not.

Can this be done?