HELP!!! Need to pull certain data from a worksheet and then auto sort it on to another!!!!

I have tried everything and it just wont work.

I have a list of sales data that i need to pull from a worksheet to another worksheet and then auto sort.

On this workbook I need only the data in column A named (GSM) and all rows to the right of those to be copied over to sheet 1 and then sorted by name alphabetically in column H.

Please help is this possible?sub.xlsx

I need only selected data from column A in sheet 2 to be transferred to sheet 1 and then sorted by salesman name.

In Column A if it says "GSM" then only those rows be transferred to sheet 1 and then sorted by salesman name.

I have tried VLOOKUP and A andif but will not work.

I looked at sheet2 column A and there is no GSM entry. however, the vlookup function works as follows...

=VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match

so, for instance, if you were looking up "Enterprise", the formula would be
=VLOOKUP("Enterprise",Sheet2!$A$3:$Q$18,1,FALSE)
however, keep in mind that a vlookup will ONLY return the 1st instance of what it is looking for. any further instances will not be returned

@boomdangman

This looks simular to the link in this topic, which you marked as solved.

http://www.excelforum.com/excel-form...html?p=2891072