Profile vs. Users sheet

Is there ever a time where the Profile sheet is in direct conflict with the User sheet? Just trying to make sure I am pulling or allowing users to pull info to create their own profile page. Would love to see bragadocious Profile tab examples and workflows! thx