Linking Data between sheets that only display information based on criteria

Alan, forum rules require you to wait at least a day before bumping your thread.

I will take a look for you

OK for lack of any sample data from you, I threw this together. See if you can adapt it to what you have...

	A	B	C	D	E
1	Name	Code		Name	Code
2	aa	11		aa	11
3	bb	22		dd	11
4	cc	33		gg	11
5	dd	11		jj	11
6	ee	22
7	ff	33
8	gg	11
9	hh	22
10	ii	33
11	jj	11

D2=IFERROR(INDEX(A:A,SMALL(IF($B$2:$B$11=11,ROW($B$2:$B$11)),ROWS($A$1:A1))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Then copy down and across as needed

1. make sure all your headings on all sheets match what you have on the Asset Register.
2. Use this ARRAY formula in OOS sheet A2, copied down and across as needed...
=IFERROR(INDEX('Asset Master Register'!$A:$M,SMALL(IF('Asset Master Register'!$K$2:$K$400="out of Service",ROW('Asset Master Register'!$A$2:$A$400)),ROWS($A$1:A1)),MATCH(A$1,'Asset Master Register'!$A$1:$M$1,0)),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)