List data points from different worksheets

[adamuce]

Hi.

Hope everyone is well and in good health. I have the template below in different worksheets (same workbook) for Monday to Friday.

Is there a formula which can go through each worksheet and list out all the deals from all worksheet (from Column E). Please note even though this is a template, if there is more info coming in I increase the number of rows, so the rows may vary in each worksheet but the deals column E stays the same.

Would like not to use Macros. Thanks in advance

 

[vletm]

You should able to send a sample Excel-file with some sample data to show exact ....
... what do You have?
... what do You need? = expected results based Your data