I am looking to program my spreadsheet so that it pulls the info from my
master spreasheet to seperate them. For example, I have three sales people
submit me different information in a spreadsheet. they have their different
acount # as the heading, with differnt info on it.. Once they submit it to
me, i am looking for my spreadsheet to keep pulling info every month from the
spreadsheet they submit to me where there account is updated automatically.

spreadsheet 1 would have 88 as a colum heading for month of oct but would
have specific customer name underneath it.
spreadsheet 2 could also have 88 as a coulm heading with different customer
name for month of oct
spreadsheet 3 could also have 88 as a column again with different name.

I would like to pull their info from the all three tabs to one tab. that
would automatically fill the new spreadsheet with 88 as the heading and
different customer name underneath it. It should update automatically for
every month.

The three sales people will never have the same customerin a same mont. They
will definitely have different coulmns headings such as 88, 89,90 etc.

I know there is some "if then" statement that can be built in, however I am
not sure how to make it easy. Please advise any help would be appreciated.
Currently I am copying an pasting, which is very time consuming.