For example say I am trying to look at visits by month across multiple GA accounts in one single Tableau sheet. Is there a way to do this or would I have to create a sheet for each account within my Tableau workbook?
You'll have to do each account separately. Tableau doesn't have a way to connect to multiple accounts. You can add that to the ideas forum if you like (it may already be there).
Retrieving data ...