How to return a cell value from a sheet that is not created yet?

Hello,

I am creating a job summary sheet to collect data from sheets that will be created based on each day worked on a project.

I've created a macro that generates new sheets from a list in my summary list.

Now I want to return values in cells in my summary sheet from data in these "new" future sheets.

I want my cell C9 in Summay to return the value on cell F30 in the sheet name based on the sheet list.

Unfortunately I cannot simply select the sheet and click on F30 because this sheet has not been created yet. Once I add a new name on my summary list and play the macro to generate the new sheet I want to be able to collect data from this sheet to my summary sheet.

Thanks a lot!
Wagner