I have over 100 employees and my boss wants me to create a roster that shows a photo, name and phone number.
I am sure I could do this but how can I sort and filter when adding or deleting staff?
Look at the data merge feature.
You can use the photos and text fields together and update the InDesign file when the employee list changes:
InDesign Help | Data merge
Retrieving data ...