Need to Query data on the same Workbook
 

Hello all -
I have an excel workbook that queries external data that is stored on a
different workbook but same computer. It works fine and I haven't had any
issues with it. But, now I need to make this workbook easy to send to other
users. I would like to consolidate the data and put it on the same workbook
with my written queries. I figured it would be easy to do, similar to doing a
pivot table on sheet1, and the data source on sheet2. This would make it much
easier to send out to all the users so it can find the "data source" every
time regardless of who's computer it's on. Can anyone point me in the right
direction?
Thanks.
JT