Auto populate master sheet with value from newly created sheets

[ElPolloDiablo]

Hi everyone,

Tried looking at similar threads and solutions but as an Excel beginner I couldn't figure it out.

I'd need to automatically populate the master sheet with values from many newly created sheets. I've tried using VLOOKUP without success.

In the sample attached is one of the values I need transferred marked in green (Price). I have a working code that creates the new sheets when the number of the offer is inserted.

Thanks for any eventual help!