Hi, I'm having a few sheets which I need to consolidate (each sheet is to updated regularly). There is a same unique ID which I'd like to use as a key identifier to load the needed data. So let's say I want to have this unique ID listed in the primary column and to load desired data from each sheet to the same row against that unique ID. Row report does not work as it only loads data row by row as well as sheet summary report does not give this option. Is there any way to do that? Thank you

Best Answer