Open random workbook,new workbook and copy some data.

Hello all,
So I know I'm biting off more than I can chew on this one, but I love a good challange. Below is my code I have so far. What I would like to do is have a button that when pressed does the following:

opens a selectable workbook and opens a new workbook.
For this example copy D1 from the selcted workbook to the new workbook.

This is as far as I've gotten and here is the code so far that does not work.

Please Login or Register  to view this content.

Long term, it will then save the new workbook with an input box answer and close the workbook all the data was copied from. (i'll cross that bridge when I get there).

Thanks!

Trying to get some help with this still. Should not be that hard, I feel like I'm close, but can't connect the dots.