Macro needed that looks up part id and returns part id

Hello,

I need a macro that looks at 13+ sheets and locates the part id that is on the master sheet and returns the value under the Parent ID that the part is structured to on the master sheet. Is this possible? Using V look up is killing the file