How do I report to User A vs User B from shared data table?
 

I need to create/distribute individual reports from one set of data. Much
like a mail merge For example, the 1st tab of my spreadsheet shows User A is
$10, User B is $20, and the total is $20. The 2nd tab shows the detail
behind User A is $7 + $3, and the detail behind User B is $15 + $5. I want
to send only User A's information to User A without seeing User B's
information, and so forth.