Cellarman
Two thoughts...
Is your database properly normalized? Specifically, why do you have so much repeating data? I realize in some cases, data will repeat itself, but I have seen far too many designs that requried repetitive entries because the design was not properly normalized. A simple example would be the customer address on invoices - since the address would exist in the customer table or an address table, the invoice would only have to reference the invoice via the foreign key vs entering the address on each invoice. This would be akin to referencing a cell in Excel with a formula instead of copying the cell.
Second, you can not cut and paste in Access as in Excel. But you can create an append query, as correctly indicated by Neil, or use VBA programming to populate records. For example, I will use VBA to populate a survey sheet or check list in this manner. How you do this will obviously depend on your data and your needs.
Richard