Pulling Data through from one sheet to another URGENT

[jonwool]

Hi All

Please can you help!! I have embarked on creating a bonus calculator sheet which I have had some help with from users of this forum over the last 24 hours and what I want it to do keeps growing!!!!

I now need the workbook to bring certain data through from a number of sheets and collate it on another sheet.

So if an entry is made on worksheets Daniel Edward, Lee Hamilton, Jamie Larkin, Alex Paramor, Joe Holden, Chris Ashford, and David Howitt and the LGE detailed in colum C is MG then the information need to be put onto the Micheala Grimshaw sheet. If the LGE in colum C is MM then the information needs to go onto the Mike Mould sheet and if the LGE is BL it needs to go onto the Ben Lockyer sheet. If N/A is selected on LGE then it does not need to go anywhere

Then on Ben, Mike's and Micheala's sheet colum C Bonus Qualifying needs to be set to yes if the corresponding entry on the othersheets has an amount in Qualifying Commission Income (Colum J on the other sheets)

I hope this make sense!!!!! Any help would be much great as I am right out of my depth!!!!

Thanks

Jon

Bonus Calculator.xls

[jonwool]

Also please note each sheet is split up into Quarters as this is how often the bonus is paid, so I need the corresponding entries to go into the right quarters. I have uploaded the spreadsheet so you can all see its layout and hopefully put in the formulars for me. Many Thanks in Advance!!