Ability to sort by Sheet, Columns, Within those columns, and Operations on Info

[TopC1]

Sorry ahead of time if the title wasn't able to convey exactly what i'm going for, but in further detail...

I have 8 sheets, 1 i'm wanting desired information to be displayed on, the other 7 are for data to be entered. What i need is the ability to get the desired information (which changes) from the other 7 sheets (whcih are updated continiously) and after determining which sheets its looking at, to determine which columns in those sheets, and then what restrcitions its using to grab information from within those columns..

example, i need information from sheets 3 and 5, but only between x and y dates.

Now that information has been sorted to the appropriate ones, perform calculations on said information, average, deviation, as well as create a graph...

Uploaded current file for visual of what im trying to accomplish. The 'search' form is the visual framework for the search filters which is Sheet, and column w/in said sheets.


possible?


Thanks in advance for any assistance on where to even start with this!