copy columns to other tabs based on searched value
 

I have a challenge on a sheet that we are using for order tracking that
I am hoping someone can help me on.

The first tab is called the "master" it contains our product list and
pricing in columns A - F
columns G-AL contain the order quantities for each store (and new
columns are inserted into this range as orders come in) columns AO-BG
contain a bunch of calculations for orders to date by product etc these
will always be shifted to the far left side of the sheet

Row 7 contains a region code for each store , say CHI (chicago) NE
(northeast)

I need a macro to search row 7 for the region name and then copy and
paste that entire column to the matching region tab

Is there an easy way to do this?

THANKS in advance!

Marty