Dynamic Range Based on Keywords

[maddclutch]

Can someone give me a hand with this? I have several charts of different types that reference data on a separate tab. The tab where the data resides is similar to this:

[TABLE="width: 687"]
<tbody>[TR]
[TD]Year
[/TD]
[TD]Quarter
[/TD]
[TD]Region
[/TD]
[TD]Period
[/TD]
[TD]Opened
[/TD]
[TD]Closed
[/TD]
[TD]Pending
[/TD]
[TD]Pending 30
[/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q1
[/TD]
[TD]Africa/ Eurasia
[/TD]
[TD]Q1 '13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q1
[/TD]
[TD]Asia
[/TD]
[TD]Q1 '13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q1
[/TD]
[TD]Europe
[/TD]
[TD]Q1 '13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q1
[/TD]
[TD]Global
[/TD]
[TD]Q1 '13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q1
[/TD]
[TD]Latin America
[/TD]
[TD]Q1 '13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q1
[/TD]
[TD]North America
[/TD]
[TD]Q1 '13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q1
[/TD]
[TD]South Pacific
[/TD]
[TD]Q1 '13
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q2
[/TD]
[TD]Africa/ Eurasia
[/TD]
[TD]Q2 '13
[/TD]
[TD]16
[/TD]
[TD]14
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q2
[/TD]
[TD]Asia
[/TD]
[TD]Q2 '13
[/TD]
[TD]7
[/TD]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q2
[/TD]
[TD]Europe
[/TD]
[TD]Q2 '13
[/TD]
[TD]19
[/TD]
[TD]16
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q2
[/TD]
[TD]Global
[/TD]
[TD]Q2 '13
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q2
[/TD]
[TD]Latin America
[/TD]
[TD]Q2 '13
[/TD]
[TD]11
[/TD]
[TD]10
[/TD]
[TD]1
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q2
[/TD]
[TD]North America
[/TD]
[TD]Q2 '13
[/TD]
[TD]41
[/TD]
[TD]41
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q2
[/TD]
[TD]South Pacific
[/TD]
[TD]Q2 '13
[/TD]
[TD]23
[/TD]
[TD]23
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q3
[/TD]
[TD]Africa/ Eurasia
[/TD]
[TD]Q3 '13
[/TD]
[TD]16
[/TD]
[TD]11
[/TD]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q3
[/TD]
[TD]Asia
[/TD]
[TD]Q3 '13
[/TD]
[TD]5
[/TD]
[TD]3
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q3
[/TD]
[TD]Europe
[/TD]
[TD]Q3 '13
[/TD]
[TD]24
[/TD]
[TD]18
[/TD]
[TD]6
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013
[/TD]
[TD]Q3
[/TD]
[TD]Global
[/TD]
[TD]Q3 '13
[/TD]
[TD]4
[/TD]
[TD]2
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Rather than manually updating the range on each chart (total of 224), is there a formula that I can use so that the range on any given chart consists of rows containing a specific region?

For example, using the above set, how would I set the range to A1:H19 WHERE C:C = North America

Any help on this would be greatly appreciated.

Thanks.