Re: Transpose/Extract data from multiple forms to another excel workbook
With respect to error handler it is good programming practice to have error handling in any module. Its a good habit to form when learning to program as users find more ways to stuff code than you can think of. I would always recommend some error handling in your code.
Yes it is possible to use titles to populate your database. What I meant by different problems this problem was copying data from one sheet to another. The next problem may be how do I get a list of all worksheets in a certain directory. Try to think of the events you want to happen and ask questions based on this.
Bottom line - I will help you if you need it and as I said there are lots of people here who can help
Have a look at this http://www.cpearson.com/excel/errorhandling.htm