If statement linking two tabs

[Gummyworms1234]

I am trying to make employee works schedules for first shift and I want to change cells based off of what's in a different tab using an if statement. I want the if statement to change any cell with a number 8 in it to change to the number referenced in the location column of the corresponding row or if it has the word off in the cell, change to show x in the cell.

The formula I'm currently trying but isn't working for me is IF(ISNUMBER(Sheet4!B7),Sheet4!A7,"x")

The first image I've attached is an example of how the schedules typically looks in the first tab and the second image is how I want it to look in the second tab.

Thanks for the help!

 

[Dossfm0q]

Hi what about This

hfg.xlsm
	A	B	C	D	E	F	G	H
5	Tab2
6		sun	mon	tue	wed	thu	fri	sat
7	1001	x	1001	1001	1001	x	x	1001
8	1002	x	x	1002	1002	1002	1002	x
9	1003	1003	1003	1003	1003	x	x	x
10	1004	1004	x	x	x	1004	1004	1004
11	1005	1005	1005	x	x	1005	1005	1005
Sheet2

Cell Formulas
Range	Formula
B7:H11	B7	=IF(ISNUMBER(Sheet4!B7),Sheet4!$A7,"x")

 

[Gummyworms1234]

Hi what about This

hfg.xlsm
	A	B	C	D	E	F	G	H
5	Tab2
6		sun	mon	tue	wed	thu	fri	sat
7	1001	x	1001	1001	1001	x	x	1001
8	1002	x	x	1002	1002	1002	1002	x
9	1003	1003	1003	1003	1003	x	x	x
10	1004	1004	x	x	x	1004	1004	1004
11	1005	1005	1005	x	x	1005	1005	1005
Sheet2

Cell Formulas
Range	Formula
B7:H11	B7	=IF(ISNUMBER(Sheet4!B7),Sheet4!$A7,"x")

I feel silly realizing I was only missing the dollar sign but this was what I needed. Thanks!