I am trying to pull the data from sheet 1, using the following formula:
=query(Sheet1!A1:V1850,"select I,A,D,E,F,H,R,S,L, M,O where I = 'TODAY()'")
So I do not have to enter todays date every time. How can it get it to pull that information?
To select the rows with today's date, the query string should be of the form
=query(..., "select ... where I = date '" & text(today(), "yyyy-mm-dd") & "'")
date 'followed by
', achieving the required format.
Putting 'TODAY()' within a double quoted string does not make it a formula: it's just the word TODAY(), treated as a part of that string. Formulas should be kept outside of strings, with their output concatenated to them as shown above.