I am trying to capture data into a single cell from a user that may require some calculations from a series of inputs.

For instance, I have a field on my main worksheet that a user can fill in if they know the total value, or if needed they can press a button that opens a small window where they can enter in a series of values which are then calculated with the result populating the field back on the main worksheet.