Hi,

I've got a template I've made. Generally these templates contained things like vlookup, and index/match with references to other sheets in the workbook and other sheets in different workbooks.

The problem I am having is when I copy a sheet from one workbook to a different work book.
If that sheet reference a value thats located in a different sheet in workbook number 1 it will still reference that value when it gets copied to workbook number 2.

As an example

Workbook one sheet one

Hi | 200
Bye | 100


Workbook one sheet one

Bye | 
=VLOOKUP(A1,[Book1]Sheet1!A:B,2,FALSE)
Now I open a new workbook up
Workbook 2 sheet 1

Hi | 70
Bye | 450

Workbook 2 sheet two
I copy and past sheet 2 from work book one and I get
Bye | 
=VLOOKUP(A1,[Book1]Sheet1!A:B,2,FALSE)
What I want is it to reference the current workbook.