VBA search and find exact matches on all sheets then copy contents of cell

[jsmith2094]

Hey,

I have a workbook that has multiple sheets , on sheet1 I have data in column A which each cell has text and numbers for example: 10404040405 John Smith LTD, each other sheets on the workbook are the same.

I need a macro that searches the numbers only in column A on sheet1 and finds the exact match on the other sheets then from the sheet it finds it from copy the contents on column E which has a price for example £9.99 then paste it back in sheet1 column E

any ideas?