|Maybe it's me, but I'm still not sure if you want 4 values (one from each sheet) or just 1.|
In your OP you asked for the last cell in the range D74:X74, which is a horizontal range in the same row, but now you are asking for the last value in T1:T33, which is a vertical range in column T.
I, for one, am confused as to what you want.
Perhaps you should post some examples of your data and the desired output based on that data.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.