How do you code in VB script to extract data from all worksheets in an Excel Spreadsheet to one worksheet?

I have three spreadsheets in an excel file called book.xlsx.

1st spreadsheet contains following data.

account first_name last_name zip rate
1 mike test 66550 G
2 adam test2 75689 G

2nd spreadsheet contains following data.

account first_name last_name zip rate
5 jill test4 55550 G


3rd spreadsheet contains following data.

account first_name last_name zip rate
7 nancy test3 60555 G
10 linda test5 77554 A
11 marcie test6 77777 C

Would like to combine all of these results into 1 worksheet. Would only like to have first_name,last_name and rate columns in a new worksheet.
Ignore column headings and omit account and zip column. How would you script this in Visual Basic?
NOTE: First row of data with column heading starts on row 10 for all worksheets. So, we want to grab any data starting from row 11.

Desire results in a new Excel worksheet:

mike test G
adam test2 G
jill test4 G
nancy test3 G
linda test5 A
marcie test6 C