Its the software version of a middleman. You might have two applications that your company uses heavily. One used by salespeople and another used by behind-the-scenes employees. If they need to share information readily but don't have an easy way for the two applications to 'converse', a middleware application might act as a buffer between the two in order to ensure smooth operation and improve efficiency.
That's just one, simple example of course.