Conceptual question - how to get started

[erniepoe]

Hi all,

The front page summary tab in my model has a mix of values from all 3 financial statements, among other things. Each month, it will get updated with new actuals, revenues, future capital raise assumptions, etc). In order to isolate the impact of each input, it becomes a very manual process of inputting one value, copying the tab then paste value, input another value, copy the tab and paste values, etc.... as each input would affect many line items, so this is a quick and easy way to isolate a single input.

I would like to improve on this process. I was originally thinking to run a multi-variable regression, but I think that's just overkill. Any suggestions on formulas, videos, etc that might help solve this issue in a more elegant way?

Thanks so much for any advice, and apologies for the unique (and perhaps a waste of time) question.

 

[MARK858]

First impression to me is you probably should be looking at utilizing something like Power Query.

Combine Data From Multiple Worksheets into a Single Worksheet in Excel

In this tutorial, you'll learn how to quickly combine data from multiple sheets into one single worksheet (using Power Query).

trumpexcel.com