Urgent Help Needed To auto populate my form using formulas (With sample attached)

Hey Guys need some help copying cells, will try explain my process as good as possible. It is across 2 sheets.

The cells I want to fill are in coloumn V in sheet 2. ie v10, v11, v12, etc.

On sheet 2 column d comtains an item count and V is the count of that item.

Then on sheet 1 column ranges (B4 To B49) (G4 To G49) (L4 To L49) (Q4 To Q49) containt the relevenant item code to column D on sheet 2. Also on sheet one the count section that I want copied into V on sheet 2 which is columns D,I, N,S 4-49 etc..

My issue is that sheet 1 is constantly rearranging and sheet 2 is in numerical order of column D.

So how do I get sheet 2 V10 to populate by searching for the item code of D10 on sheet 2 in B,G,L,Q of sheet 1 then once located to then copy the contents of the number from D,I,N,S that works with the item list?

Then once done, I want to copy the formula all the way down column V in sheet 2?

I hope this makes sense