Getting Max/Min,Last Filled Row# from Multi-Sheets same Format different Rows.

Getting Max & Min and Last Filled Row No from Multiple Sheets with the same Format from a specific Column.

Dear Forum,

I need to get the Max and the Min Values for a particular Lookup Value and also the Last Filled Row No from Multiple SHeets.

Basically, to make comparisons from all the Sheets...under consideration....

Warm Regards
e4excel