Formula to lock cell reference

Hello Jeff,

Thank you for your reply.

I am sending the file before - empty one. The file after is with the data I filled in and yellow highlighted those I am trying to get automated. I am aslo including the master file from where to pull the data.

I trust I am sending all you require.

Katerina