Use OFFSET/INDIRECT/INDEX/MATCH (or any combo) to find value across multiple worksheets

[kkrauseTX]

I want to prepare a SUMMARY page that finds a corresponding ITEM# on the Summary page within the other 6 worksheet. The ITEM# will appear on ONCE on a single workbook and they will NOT be in alpha/numeric order (so LOOKUP/HLOOKUP/VLOOKUP won't work).

The formulas needed will need to match the ITEM # on the SUMMARY page that is contained with one of the six worksheets --- BREAD (1st worksheet) through VEGETABLES (last worksheet) and return:
1) The worksheet name where the ITEM# is found (green-colored section)
2) Use OFFSET to go down X rows to pull-in the Total Fees line and the X column for the respective month (peach-colored section)

The formula should be repeatable so that it can be replicated to all the cells w/in each respective colored section.

I'm sure there is a combo formula using OFFSET/INDIRECT/INDEX/MATCH somehow that will make this work but I'm coming up empty when trying to find it across multiple worksheets. Any help on this would be greatly appreciated.

Thanks.

Sample Data:

SUMMARY SHEET
Match the ITEM# on SUMMARY to find it in the other 3 worksheets (WS01, WS02, WS03) and return the Worksheet Name AND the Total Fees for the respective month.
NOTE: On the SUMMARY sheet, the ITEM # is hard-keyed in. Columns 2-6 need formulas to find and bring in the respective results.

	A	B	C	D	E	F
1	ITEM #	Worksheet Name	Jul-2016	Aug-2016	Sep-2016	Oct-2016
2	WB999	WS01	600	500	500	500
3	AC111 <tbody> </tbody>	WS02	0	600	400	400
4	OR888 <tbody> </tbody>	WS03	0	900	1100	800
5	WB111	WS01	0	0	950	750

<tbody>
</tbody>

WORKSHEET 1 named "WS01": (contains multiple items listed down the page)

	A	B	C	D	E	F
1	ITEM #	WB999
2
3			Jul-2016	Aug-2016	Sep-2016	Oct-2016
4		Initial Fee	100
5		Monthly Fee	500	500	500	500
6		Other Fee
7		TOTAL FEES	600	500	500	500
8
9
10	ITEM #	WB111
11
12			Jul-2016	Aug-2016	Sep-2016	Oct-2016
13		Initial Fee			250
14		Monthly Fee			700	700
15		Other Fee				50
16		TOTAL FEES	0	0	950	750

<tbody>
</tbody>

WORKSHEET 2 is named "WS02": (contains multiple items listed down the page)

	A	B	C	D	E	F
1	ITEM #	AC111
2
3			Jul-2016	Aug-2016	Sep-2016	Oct-2016
4		Initial Fee		200
5		Monthly Fee		400	400	400
6		Other Fee
7		TOTAL FEES	0	600	400	400
8
9
10	ITEM #
11
12			Jul-2016	Aug-2016	Sep-2016	Oct-2016
13		Initial Fee
14		Monthly Fee
15		Other Fee
16		TOTAL FEES	0	0	0	0

<tbody>
</tbody>

WORKSHEET 3 is named "WS03": (contains multiple items listed down the page)

	A	B	C	D	E	F
1	ITEM #	OR888
2
3			Jul-2016	Aug-2016	Sep-2016	Oct-2016
4		Initial Fee		100
5		Monthly Fee		800	800	800
6		Other Fee			300
7		TOTAL FEES	0	900	1100	800
8
9
10	ITEM #
11
12			Jul-2016	Aug-2016	Sep-2016	Oct-2016
13		Initial Fee
14		Monthly Fee
15		Other Fee
16		TOTAL FEES	0	0	0	0

<tbody>
</tbody>