Macro to find criteria and copy to next page

[aaaaaaiden]

Hi,

I am in need of a macro that will:
1. Check cell B1 for my named regions
2. Find all citys in that region from another worksheet
3. Copy the specific details
4. Highlight the information that has just been copied and create a bar chart for comparison

Data to be picked up from "Inc 8%" sheet.
Headings are the same on both the worksheet the information is being taken from and being pasted to.

I need City, Year 1 Turnover - Year 10 Turnover data to be copied.

Anymore information needed let me know

Region Help.xlsm

[aaaaaaiden]

Bumping for reply

[aaaaaaiden]

anybody offer any guidance