Each Mac that backs up to the drive connected to the AirPort Extreme will automatically create its own Time Machine sparsebundle file for the Mac, with the name of the Mac assigned to the sparsebundle, so you can identify which file is which.
So, you can have multiple Macs backing up to the hard drive at the AirPort Extreme.
Note that the hard drive connected to the USB port on the AirPort Extreme must be formatted as Mac OS Extended (Journaled), also known as HFS+.
All that you have to do is set up each Mac to back up to the hard drive connected to the AirPort Extreme and the rest will take care of itself. But, don't try to set up all of the Macs to back up at the same time. Set up one Mac to back up and let the first backup complete before you set up and run the backup for the next Mac, etc.
The only real downside to this is that each sparsebundle will automatically expand as more files are added, so you cannot place a given limit on the sparsebundle size. Basically, it's first come first served as fare as space will be concerned on the hard drive at the AirPort Extreme.
Another possible downside is that the USB port on the AirPort Extreme is an old...and slow....USB 2 design, so backups are not going to run all that quickly.