Hi Guys

So I have two spreadsheets ‘Quotes’ and ‘Acceptances’. I am trying to find a way to identify all 'accepted' jobs in the 'quotes' sheet. The quote spreadsheet has data spread out into several sheets (per month) where the acceptances are all found in one sheet (raw data). So the same job will have the same job number in both 'quotes' and 'acceptances'. what I need to do is find those job numbers (from accepted) in the 'quotes' spreadsheet and then if possible transfer some data(dates ) from the acceptances spreadsheet. Hopefully I have explained this well but let me know if further explanation is needed. I am looking how best to approach this, I think a pivot table could work but I don't know. Any suggestions?

Thanks
Matthew