Find Value over multiple sheets in one cell then paste to new sheet the prev. 2 cells

Hello Everyone.

Been doing this manually for a while and going crazy (try doing this for 700+ values at a time).

Basically, I am given a bunch of values ABCD00001234, ABCD00001235 etc...
What I need is to find all those values which are located in Cell "C" over multiple sheets (40000+ rows per sheet over 4 sheets) and then copy/paste the values in Cell "A" & "B" in the same row then paste those values into a new sheet so that I now have in one row "A" "B" "C".

Example: I am given:
ABCD00001234
ABCD00001235
ABCD00001236
ABCD00001250
ABCD00001251
ABCD00001288

I could copy, then find, then paste then copy cells A and B in that row then paste into the sheet with the values I was given so that I now have all the info like this in cells A-C

AAA55 C02 ABCD00001234
AAA55 C03 ABCD00001235
AAA55 C04 ABCD00001236
AAE45 H12 ABCD00001250
AAE46 A01 ABCD00001251
AAE87 D12 ABCD00001288

Etc.

So, if I could just get a function etc.. that would allow me to have all values C in one sheet get searched for in all columns C of the other sheets and when found have their A&B cells copied then pasted into the originating sheet as A&B so I have a finished format as above, that would be great.

I hope this makes sense

TIA

D.

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!
Keep it Simple