microsoft access courses - Uploading Spreadsheets and Worksheets into Access Databases

Hi

I could do with some advice on uplading information form spreadsheets and various worksheets within a spreadsheet into a database.

I am aware that it is possible to upload a single worksheet into an access database, my question is, is it a problem to ask the database to upload information from two separate worksheets within a spreadsheet?

Is is better to keep it as two spreadsheets?

Or can you specify certain fields off each worksheet?

What happens if someone changes a heading of a column in a worksheet, will it reject the upload? Or what if someone changed the column order?

Any advice on this would be great

Thanks