Excel 2007 : Pull data to another sheet from multiple sheets based on 1 value

Hello there,

I am new to these forums and hope you all may be able to assist me.


I have attached an small version of the workbook to make it easier to handle.

I have a worksheet named 2906. There is a value in G1 which is 2906 representing that Tab. I have 4 other sheets which represent some employess. 1 tab per employee. I need the value in G1 on sheet 2906, found on all the employee sheets and if it matches that value to pull 3 cells values from the row it matches over to sheet 2906. The value from sheet 2906 in G1 will be looking at E6 to E52 on all the employee sheets to match with. If it matches, I need the data in columns B, C and R on the matched row from the employee sheets to be placed in columns, A, B and C on the '2906' Sheet. And everytime it matches to go down the page. Hopefully I can get it to be in Date order once the data is on the 2906 sheet. Any help is greatly appreciated.


Thanks in advance,

Loppy