How to input list of values in one cell to generate table of calculated values.

I have generated a spreadsheet that calculates the center of mass of an object as a function of various inputs, such as masses of particles and separation distances. I would like to generate a table of outputs (calculated C of M) for a list of inputs - e.g., M1 = {1,2,3,4,...51,52}. I can construct the table manually by entering M1 = 1, abstracting the answer from the output cell and placing its value in a table, entering a value M1 = 2, etc. I'd like to automate it so I just enter the list of values into my input cell, and having Excel construct a table of outputs. Possibl?

Thanks for the help.

Many thanks! That works very nicely. I'm impressed with how much power and flexibility Excel has. I'm going to have to get a manual and put in a lot of time studying it to realize its power. Thanks again.