Extracting data and putting in different sheets

Sounds pretty simple.

Mockup a sample workbook showing good sample data and your desired results, point out where the results came from if not obvious in your sample data.

Then click GO ADVANCED and use the paperclip icon to post up your workbook.

It's the INVOICE column that is doing the magic here. With the Sheetname appearing in B1 on each zone sheet (by itself, just make sure sheets are named properly), the invoice column is pulling back the number of matching entries from the Main Sheet.

That formula in the invoice column is an array formula. Any changes... confirm them with a CTRL-SHIFT-ENTER to keep the array active, then copy the new formula down that column.

From there, all the other columns are using variations on an INDEX/MATCH formula to bring over the matching data from the various columns for invoice number shown.

The green section shows how far down I've copied the formulas, that much data will appear on its own.

With this layout, you need only edit the SOUTH sheet and get it working the way you wish. Then, delete the other sheets, copy SOUTH 3 times and rename the sheets to the proper region names, the sheets will immediately reorient to the new sheetname and bring in relevant data for that zone.

The "HOW TO..." choice on the menu bar above answers many questions ...

EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)