Set values in cells based on lookups in single cells

Hi

I have this complex Excel file where I can input the ID of a member in one field and get a bunch of calculation results back. I basically need to produce a file that has all of those values for a large number of members.
There is only one field where I can input the members ID one by one, the copy and paste it somewhere else. And the field cannot be duplicated.

Is there simple way to fix this? I was going for VBA, but I'm really no good at this.

Details:
In cell A1, I can input the member ID.
Whenever I input a member ID, I get the calculated values I need, in cells A2, A3, and A4.

The full list of members is in separate sheet, from cells A1 to A255. I need the values for each member outputted in C2, C3, C4, next to the correct member ID.

Thank you for helping. Much appreciated.

All right, sample file with explanation attached.

That really helped, thank you!