I am using the query function to gather data from other sheets in the same workbook. It only pulls over the data from the "teacher" sheets when at least 6 rows of data are entered. The 6 rows of data can be entered on one teacher sheet or a combination of any of the teacher sheets. If only 1 or 2 rows are entered, nothing will be pulled to the summary sheets. I'm very new to this, so I'm sure it is something I am simply not seeing.
So basically, my teachers put in their data each day under their teacher tabs and the 3 summary pages pull from there or each other. Right now I have 5 entries under teacher 1 and 1 entry under teacher 2 but if you clear one of any row, it stops pulling the data to the summaries.