(Need Help) VBA use with multiple Instances of the Excel App

I have done much research and including my "Power Programming with Excel" book but I cannot seem to grasp how I might do something like allow an inputbox to grab and reference a range fro a separate application of Excel than the one which the owns the macro. The inputbox functions within the current application, so by selecting a separate application I might as well be selecting a range of cells on a table within on an HTML file found on the internet. I would be very pleased if someone could provide me with and explain the syntax to perform such an operation (if possible). I simply want to run an inputbox, select a range from a workbook in a separate instance of excel, and import the data from that range to the instance of excel which owns the macro so that the output can be in that workbook. Thanks in advance.

It is amazing how much insight that one little bit of code gave me into the object structure of Excel and VBA. Thanks, I really appreciate your help.