Is there a way to insert records from multiple tables (20) into a single table using a macro or stored procedure. This is a recurring activity.
Yes, you can use macro or stored procedure to insert. If its a simple insert statement, use macro (you need to invoke macro, everytime you insert). If it involves parameters and complex logic, go for stored procedure (you need to invoke macro, everytime you insert).