simplifying macro to repeat steps in every sheet

i have a book set up with a few sheets with info seperated out and then a sheet contianing everything. i have a macro set up to copy and paste from one sheet into a collection sheet, and then go thru and sort all the sheets.

in my macro, i have a section for each indivitual sheet. i want to make it so it goes thru and just performes the task for all of them. i need this done so if we add more sheets in later, the macro doesnt have to be edited...

below is my macro

Please Login or Register  to view this content.

compile error: invalid or unquilifed reference

.UsedRange is highlighted

run-time error 1104
debug

Please Login or Register  to view this content.

is highlighted yellow...

help says:

Ambiguous selection

Either you have not selected a keyword or you have requested Help on a component of the integrated development environment (IDE). If you were trying to select a keyword, try reselecting a single keyword. If you were trying to get information on the IDE, click one of the following: