I am trying to populate a column on a master sheet from multiple different sup sheets.
For example, I have the master sheet that has a column labeled companies. I would like to have this column automatically populated from the other sheets that are in the workbook. But I dont want the same company listed twice on the master sheet. So If the master sheet is empty and Sheet 2 has company A listed under it and sheet 3 has company A and B, how do I get company A and company B listed on the master sheet only once.