在另一个工作簿中的另一个工作簿中常见的工作表中查找ID

I have two workbooks that contains a common project ID in two different sheets . I created a code which allows the programme to search for a unique ID in one sheet, retrieve information from that row , pertaining to that id , then pasting to the row of that corresponding project ID, to another sheet in another workbook. This code works but only works under the assumption of which both the both lists are in exactly the same order , when in actual fact they are jumbled up. So i need help to incorporate find feature in the code, which finds the project ID in one workbook sheet , retrieve the row information and paste it another workbook sheet.I have two workbooks that contains a common pro