Macro to run regressions on multiple sheets

Hello,

I am wondering if there is a way to run regressions on multiple sheets rather than one each time.

I am attaching a ready sample file which has quite a few sheets. What I want to do is run a regression on all sheets.
The dependent variable (Y) is the second column whereas the independent (X) is the first one. The constant term should be zero.

Many thanks,

Costas