I have an application I've written that pulls data from several other
workbooks in order to perform some calculations.

Right now I have it set up where I make very specific definitions
in the VB code:

Set Range = Worksheets("NamedWorkbook").Range("NamedRange")

However, this is very cumbersome because it requires too much manipulation
How can I alter my code so that users can be queried for what workbook/range
combinations match a particular request without having to name the range.

Perferable, I'd what the user to just input the name of the workbook and the
appropriate corresponding range.