Filter using mutiple sheets to create an array?

[MiniFav]

I am looking to colate a list of values which appear on multiple tabs in a work book.

Sheet 1 and 2 below have varying data but not all in the same columns.

Book1
	A	B	C
1	Numbers	Letters	Colours
2	123	abc	blue
3	456	def	red
4	789	ghi	yellow
Sheet1

Book1
	A	B	C	D
1	Shapes	Numbers	Letters	Colours
2	Circle	123	abc	red
3	Square	456	def	yellow
4	Triangle	789	ghi	blue
Sheet2

I would like sheet 3 to then filter the number columns from sheets 1 and 2 and pull any with the colour blue through. to show the below.

Book1
	A
1	Show Blue numbers
2	123
3	789
Sheet3

I can do this one sheet at a time using =FILTER(Sheet1!A2:A4,Sheet1!C2:C4="blue","") but struggling to get the array to then also check the second sheet.

I am looking to do this without macros, only formulas. Any assistance would be appreciated.

 

[Fluff]

It may be that one, or more, of the sheets doesn't have anything that meets the criteria. In which case you need to wrap the Rows(a) parts in iferror like

ra,IFERROR(ROWS(a),0),rb,ra+IFERROR(ROWS(b),0)

 

[MiniFav]

It may be that one, or more, of the sheets doesn't have anything that meets the criteria. In which case you need to wrap the Rows(a) parts in iferror like

ra,IFERROR(ROWS(a),0),rb,ra+IFERROR(ROWS(b),0)

Fantastic! thanks again for all your help.

 

[Fluff]

Glad to help & thanks for the feedback.