When you setup your datasource, you can join the data by dragging the secondary sheet onto the data pane.
A different, related method is "blending". You can setup the two sheets as seperate datasources and blend them together inside the tableau views.
I tend to promote a "join when you can, blend when you can't" strategy. Joins allow you to link the tables prior to extracting into Tableau and should be faster in most cases.