Combining data from 3 tabs

[datadummy]

I am attempting to combine data from 3 separate tabs onto one tab via a unique identifier that is on all 3 tabs. Once I have identified the unique identifier on each tab I would then like to bring over all accompanying data from each of the 3 tabs into one tab. Is this possible via a formula?

 

[cerfani]

formulas dont move data around... you set them in a cell and they will calculate a value which you can then format to display however you like. So no. If you need to physically move data from one sheet to another, you do it with mouse and keyboard (lol) or via macro. You will want to write a subroutine. Then you can look through each sheet and copy and paste data wherever you like based on whatever criteria you can think of.

 

[datadummy]

Thanks. I'm not versed in VBA so a macro is likely out of my wheel house.