Multiple sheet load in Power BI

Workaround for the solution (which i should i have thought earlier but wasn't clear that i will always get 3 sheets in workbook)

Since i only had 3 sheets in workbook, i loaded the indvidual sheet in seperate table and formatted in tabular model and then combined the three tables and created as new table which will have data from all the three sheets in expected tabular format.

Not sure how to format in tablular format if if we get multiple sheets (dynamically) in same format in workbook.

But able to solve the issue in hand :)