Essentially what I am looking to figure out in excel 2010:

-2 separate workbooks (1 full of data, other is a summary workbook)

-Need the summary workbook to create a row for every sheet in data workbook (data workbook can have anywhere from 1-? sheets- starts with minimum 1, and then sheets will be added throughout the year, sheet names will also be variable)
-In each new row, 3 cells from the data workbook sheet will be referenced.

I have created a picture of what I would like the end result to look like without any code.
I know how to reference the cells from separate workbooks, but do not want to have to manually link the files every time a new sheet is added to the data workbook.
I also have very basic knowledge of VBA so please be patient!

Thanks!