Min and Max Values on Separate Tab

[RandyD123]

I have a multi-tab spreadsheet that I want to extract the MIN and MAX values from the monthly tabs and transfer them to my "FL" tab. The code I use now does not allow for me to just drag the top value down to fill in all the cells in the columns. I think that "INDIRECT" might be what I'm looking for but not sure how to write it. Sheet can be seen here

Any help would be much appreciated. Thank you.

 

[sandy666]

I think nobody want to play with passworded workbook but maybe... who knows , the removal of the password took only 5 seconds.

Have a nice day

 

[RandyD123]

thought I removed all of that....I will edit it and remove password

 

[RandyD123]

Unprotected File is HERE Sorry for anyone that tried to help. Thought I removed all the VBA!!!

 

[sandy666]

2019-10 and later are still protected

 

[RandyD123]

no info on those tabs anyway!!

 

[sandy666]

no problem

have a nice day