Conditionally formatting a group of cells based on another worksheets columns

I am having trouble coming up with a solution to my problem and I am not sure if it can be easily solved just using conditional formatting or if it requires some kind of macro.

Here is the basic problem:

On one worksheet I have a grouping of cells, say A1:E5, and in those cells is a number or number and letter (indicating a package in this case ie 30A,77B,130C etc) and in no particular order. Now on another worksheet these same letter and number combinations are listed in a single column, say F1:F25, again in no particular order. Column G is designated for a 0 or 1, 1 meaning the package is in transit. If a cell in the G column is 1, I want the corresponding value in the F cell (ie 30A) to be highlighted but in the 1st worksheet A1:E5 (in this case 30A gets the fill).

In the below case 30A and 83A should be highlighted.

A	B	C	D	E
30A	69	72	70	52
55A	11C	7A	47A	83A
97D/97E	101B	101D	31B	110B
112A	31A	109C	126K	126
19A	93C	33A	93D	128A

Worksheet 2

F	G
30A	1
7A
109C
126
83A	1

.
.
.


Thank you for your help!

Thank you thank you thank you! Exactly what I needed! You rock.