How do I launch a file open dialog box from within a macro?

I have a spreadsheet that I want to use to analyze data that is generated from other spreadsheets. I hope to be able to set it up so that at the click of a button on my main workbook, I'll be able to get the file open dialog box, select the file, then my macro will do the rest... Any help would be AWESOME!

Thanks

Paul