Help Request On Matching Sheet Name with Column Name and then running Vlookup formula

Hi,

I am writing to seek your help (MACRO / VBA CODE / OR TIP) in Excel 2007 on the following situation:

I have workbook with sales data for 2009. There are many worksheets in the workbook, each worksheet dedicated to one sales-team (worksheet names are, colin, smith, john, harry ........etc - total 20 different sales teams). Each worksheet contains 50 rows and 14 columns in the each work sheet, rows contain name of products and columns are different months of the year.

I want to create a new worksheet for Jan sales by sales-team, so my desired worksheet will be named by month say (Jan) rows will still be products and columns will change from month name to sales-team name.

I will greatly appreciate a solution to this problem.

Regards
Intikhab

Hi and welcome to the board
Please adapt your title, removing the unnecessary "help request on.." thx