Hi guys Is it possible for a macro to retrieve a column from other sheets based on date , the sheet is ald labelled as

szToday = Format(Date, "dd-mm-yyyy")

I just need to retrieve values based on the column , the individual sheets have a row with the function today() running just wondering if this is possible ?