How do I Auto populate data from another sheet when opening the excel workbook?

I have a sheet with names of people repeating itself in a column say A in sheet 'data'. I need the unique entries of these people (not duplicate names) in another sheet, 'summary'. When I open the excel sheet, 'summary' should calculate automatically and list down the unique names of people.