I am creating workbook1 that needs to take data from workbook2. The problem is that the file location of workbook2 sometimes changes, or paths are renamed, or on a yearly basis the name of workbook2 might change. I would like to circumvent this problem with a dialogue box/input box that gets the...