Looking for FORMULA to take cells w/ data from multiple sheets and copy over to a summary

Hello,

I am looking for a formula to take the cells that contain data from sheets that contain details and to record it in a summary sheet that one could just get the gist of the information contained in the worksheet. I know this is doable by coding a sheet within the workbook-I would RATHER NOT do that, as I already have the base summary sheet created, and just need this last bit of information to complete the entire workbook.

I have attached an example in hopes that someone could assist me.

Thanks in advance

Originally Posted by FlameRetired

One more question. I just noticed the merged cells.

The merged cells in source data is a bad idea. They cause havoc with formulas. Across sheets it is worse.

Do those cells have to be merged?

They do not, sorry. Attached is the unmerged copy

The attachment here is an example - it is a simpler version of only the data that I need help constructing a formula for. In my actual workbook I am pulling more information from the "Main Area" and "Presentation Room" than what I have included here. I have removed the unnecessary data that I already have figured out.

By Base summary sheet I mean I already have the rest of the data I need summarized in a summary sheet and don't want to create a new sheet for just this information (which is what I found when I was searching the internet on my own).

Hope this answers your question