Linking worksheets without using the full file path

Hey Guys,   I have a workbook with multiple sheets. Each sheet represents a purchase order with a supplier, together with a summary sheet that I use to control payment for the individual purchase o...