I know how to set up a formula in my workbook to include data from
another workbook in the formula. However as soon as I give this
workbook to someone else, the path is different. Is there some way to
allow for this difference in the path if someone uses my workbook on
their computer, or do I need to set up a macro to run some VB to find
the file and update my workbook formula accordingly?

Any help would be appreciated.