Very carefully

Can't really tell you without knowing the precise layout of things.
Can you mock up a workbook with sheets indicative of what you actually have re: location and sheet names ?