Hello Karuna

I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.

Each sheet in the Google Spreadsheet has its own URL, though, so you would be able to create new wpDataTables from each of these sheets.