I am trying to create a function for the following:

If date = todays date or earlier
Then pull information in cells (a2, b2, and e2)
Place pulled information onto new sheet in same workbook

Is this possible? If so, any assistance would be greatly appreciated!

Shari