how to consolidate data in different excel sheets
 

Yep, more info would be good but just to start it off, if you want to get
started off ... if you want to condsolidate in a singular cell:

concatenate(cell1,cell2,cell3, etc ...)

cheers.