Recover lost excel tabs/spreadsheets from workbook

Have an excel 2007 workbook with multiple spreadsheets. For unknown reasons all the tabs have disappeared from the workbook except for one.

How can these lost tabs can be recovered?